package com.runfast.waimai.dao.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class RunfastGoodsSellRecordExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RunfastGoodsSellRecordExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andBusinessidIsNull() {
            addCriterion("businessId is null");
            return (Criteria) this;
        }

        public Criteria andBusinessidIsNotNull() {
            addCriterion("businessId is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessidEqualTo(Integer value) {
            addCriterion("businessId =", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidNotEqualTo(Integer value) {
            addCriterion("businessId <>", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidGreaterThan(Integer value) {
            addCriterion("businessId >", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidGreaterThanOrEqualTo(Integer value) {
            addCriterion("businessId >=", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidLessThan(Integer value) {
            addCriterion("businessId <", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidLessThanOrEqualTo(Integer value) {
            addCriterion("businessId <=", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidIn(List<Integer> values) {
            addCriterion("businessId in", values, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidNotIn(List<Integer> values) {
            addCriterion("businessId not in", values, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidBetween(Integer value1, Integer value2) {
            addCriterion("businessId between", value1, value2, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidNotBetween(Integer value1, Integer value2) {
            addCriterion("businessId not between", value1, value2, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessnameIsNull() {
            addCriterion("businessName is null");
            return (Criteria) this;
        }

        public Criteria andBusinessnameIsNotNull() {
            addCriterion("businessName is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessnameEqualTo(String value) {
            addCriterion("businessName =", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameNotEqualTo(String value) {
            addCriterion("businessName <>", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameGreaterThan(String value) {
            addCriterion("businessName >", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameGreaterThanOrEqualTo(String value) {
            addCriterion("businessName >=", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameLessThan(String value) {
            addCriterion("businessName <", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameLessThanOrEqualTo(String value) {
            addCriterion("businessName <=", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameLike(String value) {
            addCriterion("businessName like", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameNotLike(String value) {
            addCriterion("businessName not like", value, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameIn(List<String> values) {
            addCriterion("businessName in", values, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameNotIn(List<String> values) {
            addCriterion("businessName not in", values, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameBetween(String value1, String value2) {
            addCriterion("businessName between", value1, value2, "businessname");
            return (Criteria) this;
        }

        public Criteria andBusinessnameNotBetween(String value1, String value2) {
            addCriterion("businessName not between", value1, value2, "businessname");
            return (Criteria) this;
        }

        public Criteria andContentIsNull() {
            addCriterion("content is null");
            return (Criteria) this;
        }

        public Criteria andContentIsNotNull() {
            addCriterion("content is not null");
            return (Criteria) this;
        }

        public Criteria andContentEqualTo(String value) {
            addCriterion("content =", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotEqualTo(String value) {
            addCriterion("content <>", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentGreaterThan(String value) {
            addCriterion("content >", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentGreaterThanOrEqualTo(String value) {
            addCriterion("content >=", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentLessThan(String value) {
            addCriterion("content <", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentLessThanOrEqualTo(String value) {
            addCriterion("content <=", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentLike(String value) {
            addCriterion("content like", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotLike(String value) {
            addCriterion("content not like", value, "content");
            return (Criteria) this;
        }

        public Criteria andContentIn(List<String> values) {
            addCriterion("content in", values, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotIn(List<String> values) {
            addCriterion("content not in", values, "content");
            return (Criteria) this;
        }

        public Criteria andContentBetween(String value1, String value2) {
            addCriterion("content between", value1, value2, "content");
            return (Criteria) this;
        }

        public Criteria andContentNotBetween(String value1, String value2) {
            addCriterion("content not between", value1, value2, "content");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andGoodssellidIsNull() {
            addCriterion("goodsSellId is null");
            return (Criteria) this;
        }

        public Criteria andGoodssellidIsNotNull() {
            addCriterion("goodsSellId is not null");
            return (Criteria) this;
        }

        public Criteria andGoodssellidEqualTo(Integer value) {
            addCriterion("goodsSellId =", value, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidNotEqualTo(Integer value) {
            addCriterion("goodsSellId <>", value, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidGreaterThan(Integer value) {
            addCriterion("goodsSellId >", value, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidGreaterThanOrEqualTo(Integer value) {
            addCriterion("goodsSellId >=", value, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidLessThan(Integer value) {
            addCriterion("goodsSellId <", value, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidLessThanOrEqualTo(Integer value) {
            addCriterion("goodsSellId <=", value, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidIn(List<Integer> values) {
            addCriterion("goodsSellId in", values, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidNotIn(List<Integer> values) {
            addCriterion("goodsSellId not in", values, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidBetween(Integer value1, Integer value2) {
            addCriterion("goodsSellId between", value1, value2, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellidNotBetween(Integer value1, Integer value2) {
            addCriterion("goodsSellId not between", value1, value2, "goodssellid");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameIsNull() {
            addCriterion("goodsSellName is null");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameIsNotNull() {
            addCriterion("goodsSellName is not null");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameEqualTo(String value) {
            addCriterion("goodsSellName =", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameNotEqualTo(String value) {
            addCriterion("goodsSellName <>", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameGreaterThan(String value) {
            addCriterion("goodsSellName >", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameGreaterThanOrEqualTo(String value) {
            addCriterion("goodsSellName >=", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameLessThan(String value) {
            addCriterion("goodsSellName <", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameLessThanOrEqualTo(String value) {
            addCriterion("goodsSellName <=", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameLike(String value) {
            addCriterion("goodsSellName like", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameNotLike(String value) {
            addCriterion("goodsSellName not like", value, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameIn(List<String> values) {
            addCriterion("goodsSellName in", values, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameNotIn(List<String> values) {
            addCriterion("goodsSellName not in", values, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameBetween(String value1, String value2) {
            addCriterion("goodsSellName between", value1, value2, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andGoodssellnameNotBetween(String value1, String value2) {
            addCriterion("goodsSellName not between", value1, value2, "goodssellname");
            return (Criteria) this;
        }

        public Criteria andOrdercodeIsNull() {
            addCriterion("orderCode is null");
            return (Criteria) this;
        }

        public Criteria andOrdercodeIsNotNull() {
            addCriterion("orderCode is not null");
            return (Criteria) this;
        }

        public Criteria andOrdercodeEqualTo(String value) {
            addCriterion("orderCode =", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeNotEqualTo(String value) {
            addCriterion("orderCode <>", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeGreaterThan(String value) {
            addCriterion("orderCode >", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeGreaterThanOrEqualTo(String value) {
            addCriterion("orderCode >=", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeLessThan(String value) {
            addCriterion("orderCode <", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeLessThanOrEqualTo(String value) {
            addCriterion("orderCode <=", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeLike(String value) {
            addCriterion("orderCode like", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeNotLike(String value) {
            addCriterion("orderCode not like", value, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeIn(List<String> values) {
            addCriterion("orderCode in", values, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeNotIn(List<String> values) {
            addCriterion("orderCode not in", values, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeBetween(String value1, String value2) {
            addCriterion("orderCode between", value1, value2, "ordercode");
            return (Criteria) this;
        }

        public Criteria andOrdercodeNotBetween(String value1, String value2) {
            addCriterion("orderCode not between", value1, value2, "ordercode");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andUseraddressIsNull() {
            addCriterion("userAddress is null");
            return (Criteria) this;
        }

        public Criteria andUseraddressIsNotNull() {
            addCriterion("userAddress is not null");
            return (Criteria) this;
        }

        public Criteria andUseraddressEqualTo(String value) {
            addCriterion("userAddress =", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressNotEqualTo(String value) {
            addCriterion("userAddress <>", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressGreaterThan(String value) {
            addCriterion("userAddress >", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressGreaterThanOrEqualTo(String value) {
            addCriterion("userAddress >=", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressLessThan(String value) {
            addCriterion("userAddress <", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressLessThanOrEqualTo(String value) {
            addCriterion("userAddress <=", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressLike(String value) {
            addCriterion("userAddress like", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressNotLike(String value) {
            addCriterion("userAddress not like", value, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressIn(List<String> values) {
            addCriterion("userAddress in", values, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressNotIn(List<String> values) {
            addCriterion("userAddress not in", values, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressBetween(String value1, String value2) {
            addCriterion("userAddress between", value1, value2, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseraddressNotBetween(String value1, String value2) {
            addCriterion("userAddress not between", value1, value2, "useraddress");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("userId is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("userId is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Integer value) {
            addCriterion("userId =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Integer value) {
            addCriterion("userId <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Integer value) {
            addCriterion("userId >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("userId >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Integer value) {
            addCriterion("userId <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Integer value) {
            addCriterion("userId <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Integer> values) {
            addCriterion("userId in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Integer> values) {
            addCriterion("userId not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Integer value1, Integer value2) {
            addCriterion("userId between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Integer value1, Integer value2) {
            addCriterion("userId not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUsermobileIsNull() {
            addCriterion("userMobile is null");
            return (Criteria) this;
        }

        public Criteria andUsermobileIsNotNull() {
            addCriterion("userMobile is not null");
            return (Criteria) this;
        }

        public Criteria andUsermobileEqualTo(String value) {
            addCriterion("userMobile =", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileNotEqualTo(String value) {
            addCriterion("userMobile <>", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileGreaterThan(String value) {
            addCriterion("userMobile >", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileGreaterThanOrEqualTo(String value) {
            addCriterion("userMobile >=", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileLessThan(String value) {
            addCriterion("userMobile <", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileLessThanOrEqualTo(String value) {
            addCriterion("userMobile <=", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileLike(String value) {
            addCriterion("userMobile like", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileNotLike(String value) {
            addCriterion("userMobile not like", value, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileIn(List<String> values) {
            addCriterion("userMobile in", values, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileNotIn(List<String> values) {
            addCriterion("userMobile not in", values, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileBetween(String value1, String value2) {
            addCriterion("userMobile between", value1, value2, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsermobileNotBetween(String value1, String value2) {
            addCriterion("userMobile not between", value1, value2, "usermobile");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNull() {
            addCriterion("userName is null");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNotNull() {
            addCriterion("userName is not null");
            return (Criteria) this;
        }

        public Criteria andUsernameEqualTo(String value) {
            addCriterion("userName =", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotEqualTo(String value) {
            addCriterion("userName <>", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThan(String value) {
            addCriterion("userName >", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("userName >=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThan(String value) {
            addCriterion("userName <", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThanOrEqualTo(String value) {
            addCriterion("userName <=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLike(String value) {
            addCriterion("userName like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotLike(String value) {
            addCriterion("userName not like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameIn(List<String> values) {
            addCriterion("userName in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotIn(List<String> values) {
            addCriterion("userName not in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameBetween(String value1, String value2) {
            addCriterion("userName between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotBetween(String value1, String value2) {
            addCriterion("userName not between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andShopperIsNull() {
            addCriterion("shopper is null");
            return (Criteria) this;
        }

        public Criteria andShopperIsNotNull() {
            addCriterion("shopper is not null");
            return (Criteria) this;
        }

        public Criteria andShopperEqualTo(String value) {
            addCriterion("shopper =", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperNotEqualTo(String value) {
            addCriterion("shopper <>", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperGreaterThan(String value) {
            addCriterion("shopper >", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperGreaterThanOrEqualTo(String value) {
            addCriterion("shopper >=", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperLessThan(String value) {
            addCriterion("shopper <", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperLessThanOrEqualTo(String value) {
            addCriterion("shopper <=", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperLike(String value) {
            addCriterion("shopper like", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperNotLike(String value) {
            addCriterion("shopper not like", value, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperIn(List<String> values) {
            addCriterion("shopper in", values, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperNotIn(List<String> values) {
            addCriterion("shopper not in", values, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperBetween(String value1, String value2) {
            addCriterion("shopper between", value1, value2, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperNotBetween(String value1, String value2) {
            addCriterion("shopper not between", value1, value2, "shopper");
            return (Criteria) this;
        }

        public Criteria andShopperidIsNull() {
            addCriterion("shopperId is null");
            return (Criteria) this;
        }

        public Criteria andShopperidIsNotNull() {
            addCriterion("shopperId is not null");
            return (Criteria) this;
        }

        public Criteria andShopperidEqualTo(Integer value) {
            addCriterion("shopperId =", value, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidNotEqualTo(Integer value) {
            addCriterion("shopperId <>", value, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidGreaterThan(Integer value) {
            addCriterion("shopperId >", value, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidGreaterThanOrEqualTo(Integer value) {
            addCriterion("shopperId >=", value, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidLessThan(Integer value) {
            addCriterion("shopperId <", value, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidLessThanOrEqualTo(Integer value) {
            addCriterion("shopperId <=", value, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidIn(List<Integer> values) {
            addCriterion("shopperId in", values, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidNotIn(List<Integer> values) {
            addCriterion("shopperId not in", values, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidBetween(Integer value1, Integer value2) {
            addCriterion("shopperId between", value1, value2, "shopperid");
            return (Criteria) this;
        }

        public Criteria andShopperidNotBetween(Integer value1, Integer value2) {
            addCriterion("shopperId not between", value1, value2, "shopperid");
            return (Criteria) this;
        }

        public Criteria andGoodstotalIsNull() {
            addCriterion("goodsTotal is null");
            return (Criteria) this;
        }

        public Criteria andGoodstotalIsNotNull() {
            addCriterion("goodsTotal is not null");
            return (Criteria) this;
        }

        public Criteria andGoodstotalEqualTo(Integer value) {
            addCriterion("goodsTotal =", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalNotEqualTo(Integer value) {
            addCriterion("goodsTotal <>", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalGreaterThan(Integer value) {
            addCriterion("goodsTotal >", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalGreaterThanOrEqualTo(Integer value) {
            addCriterion("goodsTotal >=", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalLessThan(Integer value) {
            addCriterion("goodsTotal <", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalLessThanOrEqualTo(Integer value) {
            addCriterion("goodsTotal <=", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalIn(List<Integer> values) {
            addCriterion("goodsTotal in", values, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalNotIn(List<Integer> values) {
            addCriterion("goodsTotal not in", values, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalBetween(Integer value1, Integer value2) {
            addCriterion("goodsTotal between", value1, value2, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalNotBetween(Integer value1, Integer value2) {
            addCriterion("goodsTotal not between", value1, value2, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andUseraddressidIsNull() {
            addCriterion("userAddressId is null");
            return (Criteria) this;
        }

        public Criteria andUseraddressidIsNotNull() {
            addCriterion("userAddressId is not null");
            return (Criteria) this;
        }

        public Criteria andUseraddressidEqualTo(Integer value) {
            addCriterion("userAddressId =", value, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidNotEqualTo(Integer value) {
            addCriterion("userAddressId <>", value, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidGreaterThan(Integer value) {
            addCriterion("userAddressId >", value, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidGreaterThanOrEqualTo(Integer value) {
            addCriterion("userAddressId >=", value, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidLessThan(Integer value) {
            addCriterion("userAddressId <", value, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidLessThanOrEqualTo(Integer value) {
            addCriterion("userAddressId <=", value, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidIn(List<Integer> values) {
            addCriterion("userAddressId in", values, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidNotIn(List<Integer> values) {
            addCriterion("userAddressId not in", values, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidBetween(Integer value1, Integer value2) {
            addCriterion("userAddressId between", value1, value2, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andUseraddressidNotBetween(Integer value1, Integer value2) {
            addCriterion("userAddressId not between", value1, value2, "useraddressid");
            return (Criteria) this;
        }

        public Criteria andYhpriceIsNull() {
            addCriterion("yhprice is null");
            return (Criteria) this;
        }

        public Criteria andYhpriceIsNotNull() {
            addCriterion("yhprice is not null");
            return (Criteria) this;
        }

        public Criteria andYhpriceEqualTo(Double value) {
            addCriterion("yhprice =", value, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceNotEqualTo(Double value) {
            addCriterion("yhprice <>", value, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceGreaterThan(Double value) {
            addCriterion("yhprice >", value, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("yhprice >=", value, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceLessThan(Double value) {
            addCriterion("yhprice <", value, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceLessThanOrEqualTo(Double value) {
            addCriterion("yhprice <=", value, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceIn(List<Double> values) {
            addCriterion("yhprice in", values, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceNotIn(List<Double> values) {
            addCriterion("yhprice not in", values, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceBetween(Double value1, Double value2) {
            addCriterion("yhprice between", value1, value2, "yhprice");
            return (Criteria) this;
        }

        public Criteria andYhpriceNotBetween(Double value1, Double value2) {
            addCriterion("yhprice not between", value1, value2, "yhprice");
            return (Criteria) this;
        }

        public Criteria andPackingIsNull() {
            addCriterion("packing is null");
            return (Criteria) this;
        }

        public Criteria andPackingIsNotNull() {
            addCriterion("packing is not null");
            return (Criteria) this;
        }

        public Criteria andPackingEqualTo(BigDecimal value) {
            addCriterion("packing =", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingNotEqualTo(BigDecimal value) {
            addCriterion("packing <>", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingGreaterThan(BigDecimal value) {
            addCriterion("packing >", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("packing >=", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingLessThan(BigDecimal value) {
            addCriterion("packing <", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("packing <=", value, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingIn(List<BigDecimal> values) {
            addCriterion("packing in", values, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingNotIn(List<BigDecimal> values) {
            addCriterion("packing not in", values, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("packing between", value1, value2, "packing");
            return (Criteria) this;
        }

        public Criteria andPackingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("packing not between", value1, value2, "packing");
            return (Criteria) this;
        }

        public Criteria andShowpsIsNull() {
            addCriterion("showps is null");
            return (Criteria) this;
        }

        public Criteria andShowpsIsNotNull() {
            addCriterion("showps is not null");
            return (Criteria) this;
        }

        public Criteria andShowpsEqualTo(BigDecimal value) {
            addCriterion("showps =", value, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsNotEqualTo(BigDecimal value) {
            addCriterion("showps <>", value, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsGreaterThan(BigDecimal value) {
            addCriterion("showps >", value, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("showps >=", value, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsLessThan(BigDecimal value) {
            addCriterion("showps <", value, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("showps <=", value, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsIn(List<BigDecimal> values) {
            addCriterion("showps in", values, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsNotIn(List<BigDecimal> values) {
            addCriterion("showps not in", values, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("showps between", value1, value2, "showps");
            return (Criteria) this;
        }

        public Criteria andShowpsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("showps not between", value1, value2, "showps");
            return (Criteria) this;
        }

        public Criteria andStatstrIsNull() {
            addCriterion("statStr is null");
            return (Criteria) this;
        }

        public Criteria andStatstrIsNotNull() {
            addCriterion("statStr is not null");
            return (Criteria) this;
        }

        public Criteria andStatstrEqualTo(String value) {
            addCriterion("statStr =", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrNotEqualTo(String value) {
            addCriterion("statStr <>", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrGreaterThan(String value) {
            addCriterion("statStr >", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrGreaterThanOrEqualTo(String value) {
            addCriterion("statStr >=", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrLessThan(String value) {
            addCriterion("statStr <", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrLessThanOrEqualTo(String value) {
            addCriterion("statStr <=", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrLike(String value) {
            addCriterion("statStr like", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrNotLike(String value) {
            addCriterion("statStr not like", value, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrIn(List<String> values) {
            addCriterion("statStr in", values, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrNotIn(List<String> values) {
            addCriterion("statStr not in", values, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrBetween(String value1, String value2) {
            addCriterion("statStr between", value1, value2, "statstr");
            return (Criteria) this;
        }

        public Criteria andStatstrNotBetween(String value1, String value2) {
            addCriterion("statStr not between", value1, value2, "statstr");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNull() {
            addCriterion("endDate is null");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNotNull() {
            addCriterion("endDate is not null");
            return (Criteria) this;
        }

        public Criteria andEnddateEqualTo(Date value) {
            addCriterion("endDate =", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotEqualTo(Date value) {
            addCriterion("endDate <>", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThan(Date value) {
            addCriterion("endDate >", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThanOrEqualTo(Date value) {
            addCriterion("endDate >=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThan(Date value) {
            addCriterion("endDate <", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThanOrEqualTo(Date value) {
            addCriterion("endDate <=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateIn(List<Date> values) {
            addCriterion("endDate in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotIn(List<Date> values) {
            addCriterion("endDate not in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateBetween(Date value1, Date value2) {
            addCriterion("endDate between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotBetween(Date value1, Date value2) {
            addCriterion("endDate not between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andRidIsNull() {
            addCriterion("rid is null");
            return (Criteria) this;
        }

        public Criteria andRidIsNotNull() {
            addCriterion("rid is not null");
            return (Criteria) this;
        }

        public Criteria andRidEqualTo(Integer value) {
            addCriterion("rid =", value, "rid");
            return (Criteria) this;
        }

        public Criteria andRidNotEqualTo(Integer value) {
            addCriterion("rid <>", value, "rid");
            return (Criteria) this;
        }

        public Criteria andRidGreaterThan(Integer value) {
            addCriterion("rid >", value, "rid");
            return (Criteria) this;
        }

        public Criteria andRidGreaterThanOrEqualTo(Integer value) {
            addCriterion("rid >=", value, "rid");
            return (Criteria) this;
        }

        public Criteria andRidLessThan(Integer value) {
            addCriterion("rid <", value, "rid");
            return (Criteria) this;
        }

        public Criteria andRidLessThanOrEqualTo(Integer value) {
            addCriterion("rid <=", value, "rid");
            return (Criteria) this;
        }

        public Criteria andRidIn(List<Integer> values) {
            addCriterion("rid in", values, "rid");
            return (Criteria) this;
        }

        public Criteria andRidNotIn(List<Integer> values) {
            addCriterion("rid not in", values, "rid");
            return (Criteria) this;
        }

        public Criteria andRidBetween(Integer value1, Integer value2) {
            addCriterion("rid between", value1, value2, "rid");
            return (Criteria) this;
        }

        public Criteria andRidNotBetween(Integer value1, Integer value2) {
            addCriterion("rid not between", value1, value2, "rid");
            return (Criteria) this;
        }

        public Criteria andStartdateIsNull() {
            addCriterion("startDate is null");
            return (Criteria) this;
        }

        public Criteria andStartdateIsNotNull() {
            addCriterion("startDate is not null");
            return (Criteria) this;
        }

        public Criteria andStartdateEqualTo(Date value) {
            addCriterion("startDate =", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateNotEqualTo(Date value) {
            addCriterion("startDate <>", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateGreaterThan(Date value) {
            addCriterion("startDate >", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateGreaterThanOrEqualTo(Date value) {
            addCriterion("startDate >=", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateLessThan(Date value) {
            addCriterion("startDate <", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateLessThanOrEqualTo(Date value) {
            addCriterion("startDate <=", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateIn(List<Date> values) {
            addCriterion("startDate in", values, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateNotIn(List<Date> values) {
            addCriterion("startDate not in", values, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateBetween(Date value1, Date value2) {
            addCriterion("startDate between", value1, value2, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateNotBetween(Date value1, Date value2) {
            addCriterion("startDate not between", value1, value2, "startdate");
            return (Criteria) this;
        }

        public Criteria andTotalpayIsNull() {
            addCriterion("totalpay is null");
            return (Criteria) this;
        }

        public Criteria andTotalpayIsNotNull() {
            addCriterion("totalpay is not null");
            return (Criteria) this;
        }

        public Criteria andTotalpayEqualTo(BigDecimal value) {
            addCriterion("totalpay =", value, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayNotEqualTo(BigDecimal value) {
            addCriterion("totalpay <>", value, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayGreaterThan(BigDecimal value) {
            addCriterion("totalpay >", value, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("totalpay >=", value, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayLessThan(BigDecimal value) {
            addCriterion("totalpay <", value, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("totalpay <=", value, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayIn(List<BigDecimal> values) {
            addCriterion("totalpay in", values, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayNotIn(List<BigDecimal> values) {
            addCriterion("totalpay not in", values, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("totalpay between", value1, value2, "totalpay");
            return (Criteria) this;
        }

        public Criteria andTotalpayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("totalpay not between", value1, value2, "totalpay");
            return (Criteria) this;
        }

        public Criteria andDistanceIsNull() {
            addCriterion("distance is null");
            return (Criteria) this;
        }

        public Criteria andDistanceIsNotNull() {
            addCriterion("distance is not null");
            return (Criteria) this;
        }

        public Criteria andDistanceEqualTo(String value) {
            addCriterion("distance =", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotEqualTo(String value) {
            addCriterion("distance <>", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceGreaterThan(String value) {
            addCriterion("distance >", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceGreaterThanOrEqualTo(String value) {
            addCriterion("distance >=", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceLessThan(String value) {
            addCriterion("distance <", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceLessThanOrEqualTo(String value) {
            addCriterion("distance <=", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceLike(String value) {
            addCriterion("distance like", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotLike(String value) {
            addCriterion("distance not like", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceIn(List<String> values) {
            addCriterion("distance in", values, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotIn(List<String> values) {
            addCriterion("distance not in", values, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceBetween(String value1, String value2) {
            addCriterion("distance between", value1, value2, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotBetween(String value1, String value2) {
            addCriterion("distance not between", value1, value2, "distance");
            return (Criteria) this;
        }

        public Criteria andIswithdrawIsNull() {
            addCriterion("iswithdraw is null");
            return (Criteria) this;
        }

        public Criteria andIswithdrawIsNotNull() {
            addCriterion("iswithdraw is not null");
            return (Criteria) this;
        }

        public Criteria andIswithdrawEqualTo(Integer value) {
            addCriterion("iswithdraw =", value, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawNotEqualTo(Integer value) {
            addCriterion("iswithdraw <>", value, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawGreaterThan(Integer value) {
            addCriterion("iswithdraw >", value, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawGreaterThanOrEqualTo(Integer value) {
            addCriterion("iswithdraw >=", value, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawLessThan(Integer value) {
            addCriterion("iswithdraw <", value, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawLessThanOrEqualTo(Integer value) {
            addCriterion("iswithdraw <=", value, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawIn(List<Integer> values) {
            addCriterion("iswithdraw in", values, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawNotIn(List<Integer> values) {
            addCriterion("iswithdraw not in", values, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawBetween(Integer value1, Integer value2) {
            addCriterion("iswithdraw between", value1, value2, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andIswithdrawNotBetween(Integer value1, Integer value2) {
            addCriterion("iswithdraw not between", value1, value2, "iswithdraw");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andBusinessdelIsNull() {
            addCriterion("businessDel is null");
            return (Criteria) this;
        }

        public Criteria andBusinessdelIsNotNull() {
            addCriterion("businessDel is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessdelEqualTo(Integer value) {
            addCriterion("businessDel =", value, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelNotEqualTo(Integer value) {
            addCriterion("businessDel <>", value, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelGreaterThan(Integer value) {
            addCriterion("businessDel >", value, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelGreaterThanOrEqualTo(Integer value) {
            addCriterion("businessDel >=", value, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelLessThan(Integer value) {
            addCriterion("businessDel <", value, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelLessThanOrEqualTo(Integer value) {
            addCriterion("businessDel <=", value, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelIn(List<Integer> values) {
            addCriterion("businessDel in", values, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelNotIn(List<Integer> values) {
            addCriterion("businessDel not in", values, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelBetween(Integer value1, Integer value2) {
            addCriterion("businessDel between", value1, value2, "businessdel");
            return (Criteria) this;
        }

        public Criteria andBusinessdelNotBetween(Integer value1, Integer value2) {
            addCriterion("businessDel not between", value1, value2, "businessdel");
            return (Criteria) this;
        }

        public Criteria andIspayIsNull() {
            addCriterion("isPay is null");
            return (Criteria) this;
        }

        public Criteria andIspayIsNotNull() {
            addCriterion("isPay is not null");
            return (Criteria) this;
        }

        public Criteria andIspayEqualTo(Integer value) {
            addCriterion("isPay =", value, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayNotEqualTo(Integer value) {
            addCriterion("isPay <>", value, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayGreaterThan(Integer value) {
            addCriterion("isPay >", value, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayGreaterThanOrEqualTo(Integer value) {
            addCriterion("isPay >=", value, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayLessThan(Integer value) {
            addCriterion("isPay <", value, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayLessThanOrEqualTo(Integer value) {
            addCriterion("isPay <=", value, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayIn(List<Integer> values) {
            addCriterion("isPay in", values, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayNotIn(List<Integer> values) {
            addCriterion("isPay not in", values, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayBetween(Integer value1, Integer value2) {
            addCriterion("isPay between", value1, value2, "ispay");
            return (Criteria) this;
        }

        public Criteria andIspayNotBetween(Integer value1, Integer value2) {
            addCriterion("isPay not between", value1, value2, "ispay");
            return (Criteria) this;
        }

        public Criteria andIsrefundIsNull() {
            addCriterion("isRefund is null");
            return (Criteria) this;
        }

        public Criteria andIsrefundIsNotNull() {
            addCriterion("isRefund is not null");
            return (Criteria) this;
        }

        public Criteria andIsrefundEqualTo(Integer value) {
            addCriterion("isRefund =", value, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundNotEqualTo(Integer value) {
            addCriterion("isRefund <>", value, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundGreaterThan(Integer value) {
            addCriterion("isRefund >", value, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundGreaterThanOrEqualTo(Integer value) {
            addCriterion("isRefund >=", value, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundLessThan(Integer value) {
            addCriterion("isRefund <", value, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundLessThanOrEqualTo(Integer value) {
            addCriterion("isRefund <=", value, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundIn(List<Integer> values) {
            addCriterion("isRefund in", values, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundNotIn(List<Integer> values) {
            addCriterion("isRefund not in", values, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundBetween(Integer value1, Integer value2) {
            addCriterion("isRefund between", value1, value2, "isrefund");
            return (Criteria) this;
        }

        public Criteria andIsrefundNotBetween(Integer value1, Integer value2) {
            addCriterion("isRefund not between", value1, value2, "isrefund");
            return (Criteria) this;
        }

        public Criteria andUserdelIsNull() {
            addCriterion("userDel is null");
            return (Criteria) this;
        }

        public Criteria andUserdelIsNotNull() {
            addCriterion("userDel is not null");
            return (Criteria) this;
        }

        public Criteria andUserdelEqualTo(Integer value) {
            addCriterion("userDel =", value, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelNotEqualTo(Integer value) {
            addCriterion("userDel <>", value, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelGreaterThan(Integer value) {
            addCriterion("userDel >", value, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelGreaterThanOrEqualTo(Integer value) {
            addCriterion("userDel >=", value, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelLessThan(Integer value) {
            addCriterion("userDel <", value, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelLessThanOrEqualTo(Integer value) {
            addCriterion("userDel <=", value, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelIn(List<Integer> values) {
            addCriterion("userDel in", values, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelNotIn(List<Integer> values) {
            addCriterion("userDel not in", values, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelBetween(Integer value1, Integer value2) {
            addCriterion("userDel between", value1, value2, "userdel");
            return (Criteria) this;
        }

        public Criteria andUserdelNotBetween(Integer value1, Integer value2) {
            addCriterion("userDel not between", value1, value2, "userdel");
            return (Criteria) this;
        }

        public Criteria andIscomentIsNull() {
            addCriterion("isComent is null");
            return (Criteria) this;
        }

        public Criteria andIscomentIsNotNull() {
            addCriterion("isComent is not null");
            return (Criteria) this;
        }

        public Criteria andIscomentEqualTo(Integer value) {
            addCriterion("isComent =", value, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentNotEqualTo(Integer value) {
            addCriterion("isComent <>", value, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentGreaterThan(Integer value) {
            addCriterion("isComent >", value, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentGreaterThanOrEqualTo(Integer value) {
            addCriterion("isComent >=", value, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentLessThan(Integer value) {
            addCriterion("isComent <", value, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentLessThanOrEqualTo(Integer value) {
            addCriterion("isComent <=", value, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentIn(List<Integer> values) {
            addCriterion("isComent in", values, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentNotIn(List<Integer> values) {
            addCriterion("isComent not in", values, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentBetween(Integer value1, Integer value2) {
            addCriterion("isComent between", value1, value2, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIscomentNotBetween(Integer value1, Integer value2) {
            addCriterion("isComent not between", value1, value2, "iscoment");
            return (Criteria) this;
        }

        public Criteria andIsreceiveIsNull() {
            addCriterion("isReceive is null");
            return (Criteria) this;
        }

        public Criteria andIsreceiveIsNotNull() {
            addCriterion("isReceive is not null");
            return (Criteria) this;
        }

        public Criteria andIsreceiveEqualTo(Integer value) {
            addCriterion("isReceive =", value, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveNotEqualTo(Integer value) {
            addCriterion("isReceive <>", value, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveGreaterThan(Integer value) {
            addCriterion("isReceive >", value, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveGreaterThanOrEqualTo(Integer value) {
            addCriterion("isReceive >=", value, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveLessThan(Integer value) {
            addCriterion("isReceive <", value, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveLessThanOrEqualTo(Integer value) {
            addCriterion("isReceive <=", value, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveIn(List<Integer> values) {
            addCriterion("isReceive in", values, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveNotIn(List<Integer> values) {
            addCriterion("isReceive not in", values, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveBetween(Integer value1, Integer value2) {
            addCriterion("isReceive between", value1, value2, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIsreceiveNotBetween(Integer value1, Integer value2) {
            addCriterion("isReceive not between", value1, value2, "isreceive");
            return (Criteria) this;
        }

        public Criteria andIscancelIsNull() {
            addCriterion("isCancel is null");
            return (Criteria) this;
        }

        public Criteria andIscancelIsNotNull() {
            addCriterion("isCancel is not null");
            return (Criteria) this;
        }

        public Criteria andIscancelEqualTo(Integer value) {
            addCriterion("isCancel =", value, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelNotEqualTo(Integer value) {
            addCriterion("isCancel <>", value, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelGreaterThan(Integer value) {
            addCriterion("isCancel >", value, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelGreaterThanOrEqualTo(Integer value) {
            addCriterion("isCancel >=", value, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelLessThan(Integer value) {
            addCriterion("isCancel <", value, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelLessThanOrEqualTo(Integer value) {
            addCriterion("isCancel <=", value, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelIn(List<Integer> values) {
            addCriterion("isCancel in", values, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelNotIn(List<Integer> values) {
            addCriterion("isCancel not in", values, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelBetween(Integer value1, Integer value2) {
            addCriterion("isCancel between", value1, value2, "iscancel");
            return (Criteria) this;
        }

        public Criteria andIscancelNotBetween(Integer value1, Integer value2) {
            addCriterion("isCancel not between", value1, value2, "iscancel");
            return (Criteria) this;
        }

        public Criteria andCommissonIsNull() {
            addCriterion("commisson is null");
            return (Criteria) this;
        }

        public Criteria andCommissonIsNotNull() {
            addCriterion("commisson is not null");
            return (Criteria) this;
        }

        public Criteria andCommissonEqualTo(BigDecimal value) {
            addCriterion("commisson =", value, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonNotEqualTo(BigDecimal value) {
            addCriterion("commisson <>", value, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonGreaterThan(BigDecimal value) {
            addCriterion("commisson >", value, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("commisson >=", value, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonLessThan(BigDecimal value) {
            addCriterion("commisson <", value, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonLessThanOrEqualTo(BigDecimal value) {
            addCriterion("commisson <=", value, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonIn(List<BigDecimal> values) {
            addCriterion("commisson in", values, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonNotIn(List<BigDecimal> values) {
            addCriterion("commisson not in", values, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commisson between", value1, value2, "commisson");
            return (Criteria) this;
        }

        public Criteria andCommissonNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commisson not between", value1, value2, "commisson");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyIsNull() {
            addCriterion("shopperMoney is null");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyIsNotNull() {
            addCriterion("shopperMoney is not null");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyEqualTo(BigDecimal value) {
            addCriterion("shopperMoney =", value, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyNotEqualTo(BigDecimal value) {
            addCriterion("shopperMoney <>", value, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyGreaterThan(BigDecimal value) {
            addCriterion("shopperMoney >", value, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shopperMoney >=", value, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyLessThan(BigDecimal value) {
            addCriterion("shopperMoney <", value, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shopperMoney <=", value, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyIn(List<BigDecimal> values) {
            addCriterion("shopperMoney in", values, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyNotIn(List<BigDecimal> values) {
            addCriterion("shopperMoney not in", values, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shopperMoney between", value1, value2, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andShoppermoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shopperMoney not between", value1, value2, "shoppermoney");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatIsNull() {
            addCriterion("businessAddressLat is null");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatIsNotNull() {
            addCriterion("businessAddressLat is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatEqualTo(String value) {
            addCriterion("businessAddressLat =", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatNotEqualTo(String value) {
            addCriterion("businessAddressLat <>", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatGreaterThan(String value) {
            addCriterion("businessAddressLat >", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatGreaterThanOrEqualTo(String value) {
            addCriterion("businessAddressLat >=", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatLessThan(String value) {
            addCriterion("businessAddressLat <", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatLessThanOrEqualTo(String value) {
            addCriterion("businessAddressLat <=", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatLike(String value) {
            addCriterion("businessAddressLat like", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatNotLike(String value) {
            addCriterion("businessAddressLat not like", value, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatIn(List<String> values) {
            addCriterion("businessAddressLat in", values, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatNotIn(List<String> values) {
            addCriterion("businessAddressLat not in", values, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatBetween(String value1, String value2) {
            addCriterion("businessAddressLat between", value1, value2, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslatNotBetween(String value1, String value2) {
            addCriterion("businessAddressLat not between", value1, value2, "businessaddresslat");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngIsNull() {
            addCriterion("businessAddressLng is null");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngIsNotNull() {
            addCriterion("businessAddressLng is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngEqualTo(String value) {
            addCriterion("businessAddressLng =", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngNotEqualTo(String value) {
            addCriterion("businessAddressLng <>", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngGreaterThan(String value) {
            addCriterion("businessAddressLng >", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngGreaterThanOrEqualTo(String value) {
            addCriterion("businessAddressLng >=", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngLessThan(String value) {
            addCriterion("businessAddressLng <", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngLessThanOrEqualTo(String value) {
            addCriterion("businessAddressLng <=", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngLike(String value) {
            addCriterion("businessAddressLng like", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngNotLike(String value) {
            addCriterion("businessAddressLng not like", value, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngIn(List<String> values) {
            addCriterion("businessAddressLng in", values, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngNotIn(List<String> values) {
            addCriterion("businessAddressLng not in", values, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngBetween(String value1, String value2) {
            addCriterion("businessAddressLng between", value1, value2, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddresslngNotBetween(String value1, String value2) {
            addCriterion("businessAddressLng not between", value1, value2, "businessaddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatIsNull() {
            addCriterion("userAddressLat is null");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatIsNotNull() {
            addCriterion("userAddressLat is not null");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatEqualTo(String value) {
            addCriterion("userAddressLat =", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatNotEqualTo(String value) {
            addCriterion("userAddressLat <>", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatGreaterThan(String value) {
            addCriterion("userAddressLat >", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatGreaterThanOrEqualTo(String value) {
            addCriterion("userAddressLat >=", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatLessThan(String value) {
            addCriterion("userAddressLat <", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatLessThanOrEqualTo(String value) {
            addCriterion("userAddressLat <=", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatLike(String value) {
            addCriterion("userAddressLat like", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatNotLike(String value) {
            addCriterion("userAddressLat not like", value, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatIn(List<String> values) {
            addCriterion("userAddressLat in", values, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatNotIn(List<String> values) {
            addCriterion("userAddressLat not in", values, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatBetween(String value1, String value2) {
            addCriterion("userAddressLat between", value1, value2, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslatNotBetween(String value1, String value2) {
            addCriterion("userAddressLat not between", value1, value2, "useraddresslat");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngIsNull() {
            addCriterion("userAddressLng is null");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngIsNotNull() {
            addCriterion("userAddressLng is not null");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngEqualTo(String value) {
            addCriterion("userAddressLng =", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngNotEqualTo(String value) {
            addCriterion("userAddressLng <>", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngGreaterThan(String value) {
            addCriterion("userAddressLng >", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngGreaterThanOrEqualTo(String value) {
            addCriterion("userAddressLng >=", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngLessThan(String value) {
            addCriterion("userAddressLng <", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngLessThanOrEqualTo(String value) {
            addCriterion("userAddressLng <=", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngLike(String value) {
            addCriterion("userAddressLng like", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngNotLike(String value) {
            addCriterion("userAddressLng not like", value, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngIn(List<String> values) {
            addCriterion("userAddressLng in", values, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngNotIn(List<String> values) {
            addCriterion("userAddressLng not in", values, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngBetween(String value1, String value2) {
            addCriterion("userAddressLng between", value1, value2, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andUseraddresslngNotBetween(String value1, String value2) {
            addCriterion("userAddressLng not between", value1, value2, "useraddresslng");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrIsNull() {
            addCriterion("businessAddr is null");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrIsNotNull() {
            addCriterion("businessAddr is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrEqualTo(String value) {
            addCriterion("businessAddr =", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrNotEqualTo(String value) {
            addCriterion("businessAddr <>", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrGreaterThan(String value) {
            addCriterion("businessAddr >", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrGreaterThanOrEqualTo(String value) {
            addCriterion("businessAddr >=", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrLessThan(String value) {
            addCriterion("businessAddr <", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrLessThanOrEqualTo(String value) {
            addCriterion("businessAddr <=", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrLike(String value) {
            addCriterion("businessAddr like", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrNotLike(String value) {
            addCriterion("businessAddr not like", value, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrIn(List<String> values) {
            addCriterion("businessAddr in", values, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrNotIn(List<String> values) {
            addCriterion("businessAddr not in", values, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrBetween(String value1, String value2) {
            addCriterion("businessAddr between", value1, value2, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinessaddrNotBetween(String value1, String value2) {
            addCriterion("businessAddr not between", value1, value2, "businessaddr");
            return (Criteria) this;
        }

        public Criteria andBusinesspayIsNull() {
            addCriterion("businesspay is null");
            return (Criteria) this;
        }

        public Criteria andBusinesspayIsNotNull() {
            addCriterion("businesspay is not null");
            return (Criteria) this;
        }

        public Criteria andBusinesspayEqualTo(BigDecimal value) {
            addCriterion("businesspay =", value, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayNotEqualTo(BigDecimal value) {
            addCriterion("businesspay <>", value, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayGreaterThan(BigDecimal value) {
            addCriterion("businesspay >", value, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("businesspay >=", value, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayLessThan(BigDecimal value) {
            addCriterion("businesspay <", value, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("businesspay <=", value, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayIn(List<BigDecimal> values) {
            addCriterion("businesspay in", values, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayNotIn(List<BigDecimal> values) {
            addCriterion("businesspay not in", values, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("businesspay between", value1, value2, "businesspay");
            return (Criteria) this;
        }

        public Criteria andBusinesspayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("businesspay not between", value1, value2, "businesspay");
            return (Criteria) this;
        }

        public Criteria andRefundIsNull() {
            addCriterion("refund is null");
            return (Criteria) this;
        }

        public Criteria andRefundIsNotNull() {
            addCriterion("refund is not null");
            return (Criteria) this;
        }

        public Criteria andRefundEqualTo(BigDecimal value) {
            addCriterion("refund =", value, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundNotEqualTo(BigDecimal value) {
            addCriterion("refund <>", value, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundGreaterThan(BigDecimal value) {
            addCriterion("refund >", value, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("refund >=", value, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundLessThan(BigDecimal value) {
            addCriterion("refund <", value, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundLessThanOrEqualTo(BigDecimal value) {
            addCriterion("refund <=", value, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundIn(List<BigDecimal> values) {
            addCriterion("refund in", values, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundNotIn(List<BigDecimal> values) {
            addCriterion("refund not in", values, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refund between", value1, value2, "refund");
            return (Criteria) this;
        }

        public Criteria andRefundNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refund not between", value1, value2, "refund");
            return (Criteria) this;
        }

        public Criteria andIsdeliverIsNull() {
            addCriterion("isDeliver is null");
            return (Criteria) this;
        }

        public Criteria andIsdeliverIsNotNull() {
            addCriterion("isDeliver is not null");
            return (Criteria) this;
        }

        public Criteria andIsdeliverEqualTo(Integer value) {
            addCriterion("isDeliver =", value, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverNotEqualTo(Integer value) {
            addCriterion("isDeliver <>", value, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverGreaterThan(Integer value) {
            addCriterion("isDeliver >", value, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverGreaterThanOrEqualTo(Integer value) {
            addCriterion("isDeliver >=", value, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverLessThan(Integer value) {
            addCriterion("isDeliver <", value, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverLessThanOrEqualTo(Integer value) {
            addCriterion("isDeliver <=", value, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverIn(List<Integer> values) {
            addCriterion("isDeliver in", values, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverNotIn(List<Integer> values) {
            addCriterion("isDeliver not in", values, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverBetween(Integer value1, Integer value2) {
            addCriterion("isDeliver between", value1, value2, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andIsdeliverNotBetween(Integer value1, Integer value2) {
            addCriterion("isDeliver not between", value1, value2, "isdeliver");
            return (Criteria) this;
        }

        public Criteria andQrcodeIsNull() {
            addCriterion("qrcode is null");
            return (Criteria) this;
        }

        public Criteria andQrcodeIsNotNull() {
            addCriterion("qrcode is not null");
            return (Criteria) this;
        }

        public Criteria andQrcodeEqualTo(String value) {
            addCriterion("qrcode =", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotEqualTo(String value) {
            addCriterion("qrcode <>", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeGreaterThan(String value) {
            addCriterion("qrcode >", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeGreaterThanOrEqualTo(String value) {
            addCriterion("qrcode >=", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeLessThan(String value) {
            addCriterion("qrcode <", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeLessThanOrEqualTo(String value) {
            addCriterion("qrcode <=", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeLike(String value) {
            addCriterion("qrcode like", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotLike(String value) {
            addCriterion("qrcode not like", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeIn(List<String> values) {
            addCriterion("qrcode in", values, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotIn(List<String> values) {
            addCriterion("qrcode not in", values, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeBetween(String value1, String value2) {
            addCriterion("qrcode between", value1, value2, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotBetween(String value1, String value2) {
            addCriterion("qrcode not between", value1, value2, "qrcode");
            return (Criteria) this;
        }

        public Criteria andRefundcontextIsNull() {
            addCriterion("refundcontext is null");
            return (Criteria) this;
        }

        public Criteria andRefundcontextIsNotNull() {
            addCriterion("refundcontext is not null");
            return (Criteria) this;
        }

        public Criteria andRefundcontextEqualTo(String value) {
            addCriterion("refundcontext =", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextNotEqualTo(String value) {
            addCriterion("refundcontext <>", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextGreaterThan(String value) {
            addCriterion("refundcontext >", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextGreaterThanOrEqualTo(String value) {
            addCriterion("refundcontext >=", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextLessThan(String value) {
            addCriterion("refundcontext <", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextLessThanOrEqualTo(String value) {
            addCriterion("refundcontext <=", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextLike(String value) {
            addCriterion("refundcontext like", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextNotLike(String value) {
            addCriterion("refundcontext not like", value, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextIn(List<String> values) {
            addCriterion("refundcontext in", values, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextNotIn(List<String> values) {
            addCriterion("refundcontext not in", values, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextBetween(String value1, String value2) {
            addCriterion("refundcontext between", value1, value2, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andRefundcontextNotBetween(String value1, String value2) {
            addCriterion("refundcontext not between", value1, value2, "refundcontext");
            return (Criteria) this;
        }

        public Criteria andBusinessgetIsNull() {
            addCriterion("businessget is null");
            return (Criteria) this;
        }

        public Criteria andBusinessgetIsNotNull() {
            addCriterion("businessget is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessgetEqualTo(BigDecimal value) {
            addCriterion("businessget =", value, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetNotEqualTo(BigDecimal value) {
            addCriterion("businessget <>", value, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetGreaterThan(BigDecimal value) {
            addCriterion("businessget >", value, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("businessget >=", value, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetLessThan(BigDecimal value) {
            addCriterion("businessget <", value, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("businessget <=", value, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetIn(List<BigDecimal> values) {
            addCriterion("businessget in", values, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetNotIn(List<BigDecimal> values) {
            addCriterion("businessget not in", values, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("businessget between", value1, value2, "businessget");
            return (Criteria) this;
        }

        public Criteria andBusinessgetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("businessget not between", value1, value2, "businessget");
            return (Criteria) this;
        }

        public Criteria andCityidIsNull() {
            addCriterion("cityId is null");
            return (Criteria) this;
        }

        public Criteria andCityidIsNotNull() {
            addCriterion("cityId is not null");
            return (Criteria) this;
        }

        public Criteria andCityidEqualTo(String value) {
            addCriterion("cityId =", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotEqualTo(String value) {
            addCriterion("cityId <>", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThan(String value) {
            addCriterion("cityId >", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThanOrEqualTo(String value) {
            addCriterion("cityId >=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThan(String value) {
            addCriterion("cityId <", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThanOrEqualTo(String value) {
            addCriterion("cityId <=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLike(String value) {
            addCriterion("cityId like", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotLike(String value) {
            addCriterion("cityId not like", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidIn(List<String> values) {
            addCriterion("cityId in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotIn(List<String> values) {
            addCriterion("cityId not in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidBetween(String value1, String value2) {
            addCriterion("cityId between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotBetween(String value1, String value2) {
            addCriterion("cityId not between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCitynameIsNull() {
            addCriterion("cityName is null");
            return (Criteria) this;
        }

        public Criteria andCitynameIsNotNull() {
            addCriterion("cityName is not null");
            return (Criteria) this;
        }

        public Criteria andCitynameEqualTo(String value) {
            addCriterion("cityName =", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotEqualTo(String value) {
            addCriterion("cityName <>", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameGreaterThan(String value) {
            addCriterion("cityName >", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameGreaterThanOrEqualTo(String value) {
            addCriterion("cityName >=", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameLessThan(String value) {
            addCriterion("cityName <", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameLessThanOrEqualTo(String value) {
            addCriterion("cityName <=", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameLike(String value) {
            addCriterion("cityName like", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotLike(String value) {
            addCriterion("cityName not like", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameIn(List<String> values) {
            addCriterion("cityName in", values, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotIn(List<String> values) {
            addCriterion("cityName not in", values, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameBetween(String value1, String value2) {
            addCriterion("cityName between", value1, value2, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotBetween(String value1, String value2) {
            addCriterion("cityName not between", value1, value2, "cityname");
            return (Criteria) this;
        }

        public Criteria andCountyidIsNull() {
            addCriterion("countyId is null");
            return (Criteria) this;
        }

        public Criteria andCountyidIsNotNull() {
            addCriterion("countyId is not null");
            return (Criteria) this;
        }

        public Criteria andCountyidEqualTo(String value) {
            addCriterion("countyId =", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotEqualTo(String value) {
            addCriterion("countyId <>", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidGreaterThan(String value) {
            addCriterion("countyId >", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidGreaterThanOrEqualTo(String value) {
            addCriterion("countyId >=", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidLessThan(String value) {
            addCriterion("countyId <", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidLessThanOrEqualTo(String value) {
            addCriterion("countyId <=", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidLike(String value) {
            addCriterion("countyId like", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotLike(String value) {
            addCriterion("countyId not like", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidIn(List<String> values) {
            addCriterion("countyId in", values, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotIn(List<String> values) {
            addCriterion("countyId not in", values, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidBetween(String value1, String value2) {
            addCriterion("countyId between", value1, value2, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotBetween(String value1, String value2) {
            addCriterion("countyId not between", value1, value2, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountynameIsNull() {
            addCriterion("countyName is null");
            return (Criteria) this;
        }

        public Criteria andCountynameIsNotNull() {
            addCriterion("countyName is not null");
            return (Criteria) this;
        }

        public Criteria andCountynameEqualTo(String value) {
            addCriterion("countyName =", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotEqualTo(String value) {
            addCriterion("countyName <>", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameGreaterThan(String value) {
            addCriterion("countyName >", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameGreaterThanOrEqualTo(String value) {
            addCriterion("countyName >=", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameLessThan(String value) {
            addCriterion("countyName <", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameLessThanOrEqualTo(String value) {
            addCriterion("countyName <=", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameLike(String value) {
            addCriterion("countyName like", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotLike(String value) {
            addCriterion("countyName not like", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameIn(List<String> values) {
            addCriterion("countyName in", values, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotIn(List<String> values) {
            addCriterion("countyName not in", values, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameBetween(String value1, String value2) {
            addCriterion("countyName between", value1, value2, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotBetween(String value1, String value2) {
            addCriterion("countyName not between", value1, value2, "countyname");
            return (Criteria) this;
        }

        public Criteria andTownidIsNull() {
            addCriterion("townId is null");
            return (Criteria) this;
        }

        public Criteria andTownidIsNotNull() {
            addCriterion("townId is not null");
            return (Criteria) this;
        }

        public Criteria andTownidEqualTo(String value) {
            addCriterion("townId =", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidNotEqualTo(String value) {
            addCriterion("townId <>", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidGreaterThan(String value) {
            addCriterion("townId >", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidGreaterThanOrEqualTo(String value) {
            addCriterion("townId >=", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidLessThan(String value) {
            addCriterion("townId <", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidLessThanOrEqualTo(String value) {
            addCriterion("townId <=", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidLike(String value) {
            addCriterion("townId like", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidNotLike(String value) {
            addCriterion("townId not like", value, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidIn(List<String> values) {
            addCriterion("townId in", values, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidNotIn(List<String> values) {
            addCriterion("townId not in", values, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidBetween(String value1, String value2) {
            addCriterion("townId between", value1, value2, "townid");
            return (Criteria) this;
        }

        public Criteria andTownidNotBetween(String value1, String value2) {
            addCriterion("townId not between", value1, value2, "townid");
            return (Criteria) this;
        }

        public Criteria andTownnameIsNull() {
            addCriterion("townName is null");
            return (Criteria) this;
        }

        public Criteria andTownnameIsNotNull() {
            addCriterion("townName is not null");
            return (Criteria) this;
        }

        public Criteria andTownnameEqualTo(String value) {
            addCriterion("townName =", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameNotEqualTo(String value) {
            addCriterion("townName <>", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameGreaterThan(String value) {
            addCriterion("townName >", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameGreaterThanOrEqualTo(String value) {
            addCriterion("townName >=", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameLessThan(String value) {
            addCriterion("townName <", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameLessThanOrEqualTo(String value) {
            addCriterion("townName <=", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameLike(String value) {
            addCriterion("townName like", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameNotLike(String value) {
            addCriterion("townName not like", value, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameIn(List<String> values) {
            addCriterion("townName in", values, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameNotIn(List<String> values) {
            addCriterion("townName not in", values, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameBetween(String value1, String value2) {
            addCriterion("townName between", value1, value2, "townname");
            return (Criteria) this;
        }

        public Criteria andTownnameNotBetween(String value1, String value2) {
            addCriterion("townName not between", value1, value2, "townname");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNull() {
            addCriterion("agentId is null");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNotNull() {
            addCriterion("agentId is not null");
            return (Criteria) this;
        }

        public Criteria andAgentidEqualTo(Integer value) {
            addCriterion("agentId =", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotEqualTo(Integer value) {
            addCriterion("agentId <>", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThan(Integer value) {
            addCriterion("agentId >", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThanOrEqualTo(Integer value) {
            addCriterion("agentId >=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThan(Integer value) {
            addCriterion("agentId <", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThanOrEqualTo(Integer value) {
            addCriterion("agentId <=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidIn(List<Integer> values) {
            addCriterion("agentId in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotIn(List<Integer> values) {
            addCriterion("agentId not in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidBetween(Integer value1, Integer value2) {
            addCriterion("agentId between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotBetween(Integer value1, Integer value2) {
            addCriterion("agentId not between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNull() {
            addCriterion("agentName is null");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNotNull() {
            addCriterion("agentName is not null");
            return (Criteria) this;
        }

        public Criteria andAgentnameEqualTo(String value) {
            addCriterion("agentName =", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotEqualTo(String value) {
            addCriterion("agentName <>", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThan(String value) {
            addCriterion("agentName >", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThanOrEqualTo(String value) {
            addCriterion("agentName >=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThan(String value) {
            addCriterion("agentName <", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThanOrEqualTo(String value) {
            addCriterion("agentName <=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLike(String value) {
            addCriterion("agentName like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotLike(String value) {
            addCriterion("agentName not like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameIn(List<String> values) {
            addCriterion("agentName in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotIn(List<String> values) {
            addCriterion("agentName not in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameBetween(String value1, String value2) {
            addCriterion("agentName between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotBetween(String value1, String value2) {
            addCriterion("agentName not between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileIsNull() {
            addCriterion("businessMobile is null");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileIsNotNull() {
            addCriterion("businessMobile is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileEqualTo(String value) {
            addCriterion("businessMobile =", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileNotEqualTo(String value) {
            addCriterion("businessMobile <>", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileGreaterThan(String value) {
            addCriterion("businessMobile >", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileGreaterThanOrEqualTo(String value) {
            addCriterion("businessMobile >=", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileLessThan(String value) {
            addCriterion("businessMobile <", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileLessThanOrEqualTo(String value) {
            addCriterion("businessMobile <=", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileLike(String value) {
            addCriterion("businessMobile like", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileNotLike(String value) {
            addCriterion("businessMobile not like", value, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileIn(List<String> values) {
            addCriterion("businessMobile in", values, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileNotIn(List<String> values) {
            addCriterion("businessMobile not in", values, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileBetween(String value1, String value2) {
            addCriterion("businessMobile between", value1, value2, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andBusinessmobileNotBetween(String value1, String value2) {
            addCriterion("businessMobile not between", value1, value2, "businessmobile");
            return (Criteria) this;
        }

        public Criteria andNochargeIsNull() {
            addCriterion("noCharge is null");
            return (Criteria) this;
        }

        public Criteria andNochargeIsNotNull() {
            addCriterion("noCharge is not null");
            return (Criteria) this;
        }

        public Criteria andNochargeEqualTo(Double value) {
            addCriterion("noCharge =", value, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeNotEqualTo(Double value) {
            addCriterion("noCharge <>", value, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeGreaterThan(Double value) {
            addCriterion("noCharge >", value, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeGreaterThanOrEqualTo(Double value) {
            addCriterion("noCharge >=", value, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeLessThan(Double value) {
            addCriterion("noCharge <", value, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeLessThanOrEqualTo(Double value) {
            addCriterion("noCharge <=", value, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeIn(List<Double> values) {
            addCriterion("noCharge in", values, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeNotIn(List<Double> values) {
            addCriterion("noCharge not in", values, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeBetween(Double value1, Double value2) {
            addCriterion("noCharge between", value1, value2, "nocharge");
            return (Criteria) this;
        }

        public Criteria andNochargeNotBetween(Double value1, Double value2) {
            addCriterion("noCharge not between", value1, value2, "nocharge");
            return (Criteria) this;
        }

        public Criteria andShoppermobileIsNull() {
            addCriterion("shopperMobile is null");
            return (Criteria) this;
        }

        public Criteria andShoppermobileIsNotNull() {
            addCriterion("shopperMobile is not null");
            return (Criteria) this;
        }

        public Criteria andShoppermobileEqualTo(String value) {
            addCriterion("shopperMobile =", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileNotEqualTo(String value) {
            addCriterion("shopperMobile <>", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileGreaterThan(String value) {
            addCriterion("shopperMobile >", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileGreaterThanOrEqualTo(String value) {
            addCriterion("shopperMobile >=", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileLessThan(String value) {
            addCriterion("shopperMobile <", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileLessThanOrEqualTo(String value) {
            addCriterion("shopperMobile <=", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileLike(String value) {
            addCriterion("shopperMobile like", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileNotLike(String value) {
            addCriterion("shopperMobile not like", value, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileIn(List<String> values) {
            addCriterion("shopperMobile in", values, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileNotIn(List<String> values) {
            addCriterion("shopperMobile not in", values, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileBetween(String value1, String value2) {
            addCriterion("shopperMobile between", value1, value2, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppermobileNotBetween(String value1, String value2) {
            addCriterion("shopperMobile not between", value1, value2, "shoppermobile");
            return (Criteria) this;
        }

        public Criteria andShoppersignIsNull() {
            addCriterion("shopperSign is null");
            return (Criteria) this;
        }

        public Criteria andShoppersignIsNotNull() {
            addCriterion("shopperSign is not null");
            return (Criteria) this;
        }

        public Criteria andShoppersignEqualTo(Integer value) {
            addCriterion("shopperSign =", value, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignNotEqualTo(Integer value) {
            addCriterion("shopperSign <>", value, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignGreaterThan(Integer value) {
            addCriterion("shopperSign >", value, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignGreaterThanOrEqualTo(Integer value) {
            addCriterion("shopperSign >=", value, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignLessThan(Integer value) {
            addCriterion("shopperSign <", value, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignLessThanOrEqualTo(Integer value) {
            addCriterion("shopperSign <=", value, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignIn(List<Integer> values) {
            addCriterion("shopperSign in", values, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignNotIn(List<Integer> values) {
            addCriterion("shopperSign not in", values, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignBetween(Integer value1, Integer value2) {
            addCriterion("shopperSign between", value1, value2, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andShoppersignNotBetween(Integer value1, Integer value2) {
            addCriterion("shopperSign not between", value1, value2, "shoppersign");
            return (Criteria) this;
        }

        public Criteria andActivityidIsNull() {
            addCriterion("activityId is null");
            return (Criteria) this;
        }

        public Criteria andActivityidIsNotNull() {
            addCriterion("activityId is not null");
            return (Criteria) this;
        }

        public Criteria andActivityidEqualTo(Integer value) {
            addCriterion("activityId =", value, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidNotEqualTo(Integer value) {
            addCriterion("activityId <>", value, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidGreaterThan(Integer value) {
            addCriterion("activityId >", value, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidGreaterThanOrEqualTo(Integer value) {
            addCriterion("activityId >=", value, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidLessThan(Integer value) {
            addCriterion("activityId <", value, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidLessThanOrEqualTo(Integer value) {
            addCriterion("activityId <=", value, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidIn(List<Integer> values) {
            addCriterion("activityId in", values, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidNotIn(List<Integer> values) {
            addCriterion("activityId not in", values, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidBetween(Integer value1, Integer value2) {
            addCriterion("activityId between", value1, value2, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivityidNotBetween(Integer value1, Integer value2) {
            addCriterion("activityId not between", value1, value2, "activityid");
            return (Criteria) this;
        }

        public Criteria andActivitynameIsNull() {
            addCriterion("activityname is null");
            return (Criteria) this;
        }

        public Criteria andActivitynameIsNotNull() {
            addCriterion("activityname is not null");
            return (Criteria) this;
        }

        public Criteria andActivitynameEqualTo(String value) {
            addCriterion("activityname =", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameNotEqualTo(String value) {
            addCriterion("activityname <>", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameGreaterThan(String value) {
            addCriterion("activityname >", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameGreaterThanOrEqualTo(String value) {
            addCriterion("activityname >=", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameLessThan(String value) {
            addCriterion("activityname <", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameLessThanOrEqualTo(String value) {
            addCriterion("activityname <=", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameLike(String value) {
            addCriterion("activityname like", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameNotLike(String value) {
            addCriterion("activityname not like", value, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameIn(List<String> values) {
            addCriterion("activityname in", values, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameNotIn(List<String> values) {
            addCriterion("activityname not in", values, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameBetween(String value1, String value2) {
            addCriterion("activityname between", value1, value2, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitynameNotBetween(String value1, String value2) {
            addCriterion("activityname not between", value1, value2, "activityname");
            return (Criteria) this;
        }

        public Criteria andActivitypriceIsNull() {
            addCriterion("activityprice is null");
            return (Criteria) this;
        }

        public Criteria andActivitypriceIsNotNull() {
            addCriterion("activityprice is not null");
            return (Criteria) this;
        }

        public Criteria andActivitypriceEqualTo(BigDecimal value) {
            addCriterion("activityprice =", value, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceNotEqualTo(BigDecimal value) {
            addCriterion("activityprice <>", value, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceGreaterThan(BigDecimal value) {
            addCriterion("activityprice >", value, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("activityprice >=", value, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceLessThan(BigDecimal value) {
            addCriterion("activityprice <", value, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("activityprice <=", value, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceIn(List<BigDecimal> values) {
            addCriterion("activityprice in", values, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceNotIn(List<BigDecimal> values) {
            addCriterion("activityprice not in", values, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("activityprice between", value1, value2, "activityprice");
            return (Criteria) this;
        }

        public Criteria andActivitypriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("activityprice not between", value1, value2, "activityprice");
            return (Criteria) this;
        }

        public Criteria andDispriceIsNull() {
            addCriterion("disprice is null");
            return (Criteria) this;
        }

        public Criteria andDispriceIsNotNull() {
            addCriterion("disprice is not null");
            return (Criteria) this;
        }

        public Criteria andDispriceEqualTo(BigDecimal value) {
            addCriterion("disprice =", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceNotEqualTo(BigDecimal value) {
            addCriterion("disprice <>", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceGreaterThan(BigDecimal value) {
            addCriterion("disprice >", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("disprice >=", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceLessThan(BigDecimal value) {
            addCriterion("disprice <", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("disprice <=", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceIn(List<BigDecimal> values) {
            addCriterion("disprice in", values, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceNotIn(List<BigDecimal> values) {
            addCriterion("disprice not in", values, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("disprice between", value1, value2, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("disprice not between", value1, value2, "disprice");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeIsNull() {
            addCriterion("distributionTime is null");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeIsNotNull() {
            addCriterion("distributionTime is not null");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeEqualTo(Integer value) {
            addCriterion("distributionTime =", value, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeNotEqualTo(Integer value) {
            addCriterion("distributionTime <>", value, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeGreaterThan(Integer value) {
            addCriterion("distributionTime >", value, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeGreaterThanOrEqualTo(Integer value) {
            addCriterion("distributionTime >=", value, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeLessThan(Integer value) {
            addCriterion("distributionTime <", value, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeLessThanOrEqualTo(Integer value) {
            addCriterion("distributionTime <=", value, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeIn(List<Integer> values) {
            addCriterion("distributionTime in", values, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeNotIn(List<Integer> values) {
            addCriterion("distributionTime not in", values, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeBetween(Integer value1, Integer value2) {
            addCriterion("distributionTime between", value1, value2, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andDistributiontimeNotBetween(Integer value1, Integer value2) {
            addCriterion("distributionTime not between", value1, value2, "distributiontime");
            return (Criteria) this;
        }

        public Criteria andOldshopperIsNull() {
            addCriterion("oldShopper is null");
            return (Criteria) this;
        }

        public Criteria andOldshopperIsNotNull() {
            addCriterion("oldShopper is not null");
            return (Criteria) this;
        }

        public Criteria andOldshopperEqualTo(String value) {
            addCriterion("oldShopper =", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperNotEqualTo(String value) {
            addCriterion("oldShopper <>", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperGreaterThan(String value) {
            addCriterion("oldShopper >", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperGreaterThanOrEqualTo(String value) {
            addCriterion("oldShopper >=", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperLessThan(String value) {
            addCriterion("oldShopper <", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperLessThanOrEqualTo(String value) {
            addCriterion("oldShopper <=", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperLike(String value) {
            addCriterion("oldShopper like", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperNotLike(String value) {
            addCriterion("oldShopper not like", value, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperIn(List<String> values) {
            addCriterion("oldShopper in", values, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperNotIn(List<String> values) {
            addCriterion("oldShopper not in", values, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperBetween(String value1, String value2) {
            addCriterion("oldShopper between", value1, value2, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperNotBetween(String value1, String value2) {
            addCriterion("oldShopper not between", value1, value2, "oldshopper");
            return (Criteria) this;
        }

        public Criteria andOldshopperidIsNull() {
            addCriterion("oldShopperId is null");
            return (Criteria) this;
        }

        public Criteria andOldshopperidIsNotNull() {
            addCriterion("oldShopperId is not null");
            return (Criteria) this;
        }

        public Criteria andOldshopperidEqualTo(Integer value) {
            addCriterion("oldShopperId =", value, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidNotEqualTo(Integer value) {
            addCriterion("oldShopperId <>", value, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidGreaterThan(Integer value) {
            addCriterion("oldShopperId >", value, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidGreaterThanOrEqualTo(Integer value) {
            addCriterion("oldShopperId >=", value, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidLessThan(Integer value) {
            addCriterion("oldShopperId <", value, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidLessThanOrEqualTo(Integer value) {
            addCriterion("oldShopperId <=", value, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidIn(List<Integer> values) {
            addCriterion("oldShopperId in", values, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidNotIn(List<Integer> values) {
            addCriterion("oldShopperId not in", values, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidBetween(Integer value1, Integer value2) {
            addCriterion("oldShopperId between", value1, value2, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshopperidNotBetween(Integer value1, Integer value2) {
            addCriterion("oldShopperId not between", value1, value2, "oldshopperid");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileIsNull() {
            addCriterion("oldShopperMobile is null");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileIsNotNull() {
            addCriterion("oldShopperMobile is not null");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileEqualTo(String value) {
            addCriterion("oldShopperMobile =", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileNotEqualTo(String value) {
            addCriterion("oldShopperMobile <>", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileGreaterThan(String value) {
            addCriterion("oldShopperMobile >", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileGreaterThanOrEqualTo(String value) {
            addCriterion("oldShopperMobile >=", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileLessThan(String value) {
            addCriterion("oldShopperMobile <", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileLessThanOrEqualTo(String value) {
            addCriterion("oldShopperMobile <=", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileLike(String value) {
            addCriterion("oldShopperMobile like", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileNotLike(String value) {
            addCriterion("oldShopperMobile not like", value, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileIn(List<String> values) {
            addCriterion("oldShopperMobile in", values, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileNotIn(List<String> values) {
            addCriterion("oldShopperMobile not in", values, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileBetween(String value1, String value2) {
            addCriterion("oldShopperMobile between", value1, value2, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andOldshoppermobileNotBetween(String value1, String value2) {
            addCriterion("oldShopperMobile not between", value1, value2, "oldshoppermobile");
            return (Criteria) this;
        }

        public Criteria andAgentgetIsNull() {
            addCriterion("agentget is null");
            return (Criteria) this;
        }

        public Criteria andAgentgetIsNotNull() {
            addCriterion("agentget is not null");
            return (Criteria) this;
        }

        public Criteria andAgentgetEqualTo(BigDecimal value) {
            addCriterion("agentget =", value, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetNotEqualTo(BigDecimal value) {
            addCriterion("agentget <>", value, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetGreaterThan(BigDecimal value) {
            addCriterion("agentget >", value, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("agentget >=", value, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetLessThan(BigDecimal value) {
            addCriterion("agentget <", value, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("agentget <=", value, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetIn(List<BigDecimal> values) {
            addCriterion("agentget in", values, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetNotIn(List<BigDecimal> values) {
            addCriterion("agentget not in", values, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("agentget between", value1, value2, "agentget");
            return (Criteria) this;
        }

        public Criteria andAgentgetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("agentget not between", value1, value2, "agentget");
            return (Criteria) this;
        }

        public Criteria andAcepttimeIsNull() {
            addCriterion("aceptTime is null");
            return (Criteria) this;
        }

        public Criteria andAcepttimeIsNotNull() {
            addCriterion("aceptTime is not null");
            return (Criteria) this;
        }

        public Criteria andAcepttimeEqualTo(Date value) {
            addCriterion("aceptTime =", value, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeNotEqualTo(Date value) {
            addCriterion("aceptTime <>", value, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeGreaterThan(Date value) {
            addCriterion("aceptTime >", value, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("aceptTime >=", value, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeLessThan(Date value) {
            addCriterion("aceptTime <", value, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeLessThanOrEqualTo(Date value) {
            addCriterion("aceptTime <=", value, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeIn(List<Date> values) {
            addCriterion("aceptTime in", values, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeNotIn(List<Date> values) {
            addCriterion("aceptTime not in", values, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeBetween(Date value1, Date value2) {
            addCriterion("aceptTime between", value1, value2, "acepttime");
            return (Criteria) this;
        }

        public Criteria andAcepttimeNotBetween(Date value1, Date value2) {
            addCriterion("aceptTime not between", value1, value2, "acepttime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNull() {
            addCriterion("payTime is null");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNotNull() {
            addCriterion("payTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaytimeEqualTo(Date value) {
            addCriterion("payTime =", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotEqualTo(Date value) {
            addCriterion("payTime <>", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThan(Date value) {
            addCriterion("payTime >", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("payTime >=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThan(Date value) {
            addCriterion("payTime <", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThanOrEqualTo(Date value) {
            addCriterion("payTime <=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIn(List<Date> values) {
            addCriterion("payTime in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotIn(List<Date> values) {
            addCriterion("payTime not in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeBetween(Date value1, Date value2) {
            addCriterion("payTime between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotBetween(Date value1, Date value2) {
            addCriterion("payTime not between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andIsmuteIsNull() {
            addCriterion("ismute is null");
            return (Criteria) this;
        }

        public Criteria andIsmuteIsNotNull() {
            addCriterion("ismute is not null");
            return (Criteria) this;
        }

        public Criteria andIsmuteEqualTo(Integer value) {
            addCriterion("ismute =", value, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteNotEqualTo(Integer value) {
            addCriterion("ismute <>", value, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteGreaterThan(Integer value) {
            addCriterion("ismute >", value, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteGreaterThanOrEqualTo(Integer value) {
            addCriterion("ismute >=", value, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteLessThan(Integer value) {
            addCriterion("ismute <", value, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteLessThanOrEqualTo(Integer value) {
            addCriterion("ismute <=", value, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteIn(List<Integer> values) {
            addCriterion("ismute in", values, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteNotIn(List<Integer> values) {
            addCriterion("ismute not in", values, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteBetween(Integer value1, Integer value2) {
            addCriterion("ismute between", value1, value2, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsmuteNotBetween(Integer value1, Integer value2) {
            addCriterion("ismute not between", value1, value2, "ismute");
            return (Criteria) this;
        }

        public Criteria andIsclearingIsNull() {
            addCriterion("isClearing is null");
            return (Criteria) this;
        }

        public Criteria andIsclearingIsNotNull() {
            addCriterion("isClearing is not null");
            return (Criteria) this;
        }

        public Criteria andIsclearingEqualTo(Integer value) {
            addCriterion("isClearing =", value, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingNotEqualTo(Integer value) {
            addCriterion("isClearing <>", value, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingGreaterThan(Integer value) {
            addCriterion("isClearing >", value, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingGreaterThanOrEqualTo(Integer value) {
            addCriterion("isClearing >=", value, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingLessThan(Integer value) {
            addCriterion("isClearing <", value, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingLessThanOrEqualTo(Integer value) {
            addCriterion("isClearing <=", value, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingIn(List<Integer> values) {
            addCriterion("isClearing in", values, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingNotIn(List<Integer> values) {
            addCriterion("isClearing not in", values, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingBetween(Integer value1, Integer value2) {
            addCriterion("isClearing between", value1, value2, "isclearing");
            return (Criteria) this;
        }

        public Criteria andIsclearingNotBetween(Integer value1, Integer value2) {
            addCriterion("isClearing not between", value1, value2, "isclearing");
            return (Criteria) this;
        }

        public Criteria andRefundtimeIsNull() {
            addCriterion("refundTime is null");
            return (Criteria) this;
        }

        public Criteria andRefundtimeIsNotNull() {
            addCriterion("refundTime is not null");
            return (Criteria) this;
        }

        public Criteria andRefundtimeEqualTo(Date value) {
            addCriterion("refundTime =", value, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeNotEqualTo(Date value) {
            addCriterion("refundTime <>", value, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeGreaterThan(Date value) {
            addCriterion("refundTime >", value, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("refundTime >=", value, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeLessThan(Date value) {
            addCriterion("refundTime <", value, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeLessThanOrEqualTo(Date value) {
            addCriterion("refundTime <=", value, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeIn(List<Date> values) {
            addCriterion("refundTime in", values, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeNotIn(List<Date> values) {
            addCriterion("refundTime not in", values, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeBetween(Date value1, Date value2) {
            addCriterion("refundTime between", value1, value2, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtimeNotBetween(Date value1, Date value2) {
            addCriterion("refundTime not between", value1, value2, "refundtime");
            return (Criteria) this;
        }

        public Criteria andRefundtypeIsNull() {
            addCriterion("refundType is null");
            return (Criteria) this;
        }

        public Criteria andRefundtypeIsNotNull() {
            addCriterion("refundType is not null");
            return (Criteria) this;
        }

        public Criteria andRefundtypeEqualTo(Integer value) {
            addCriterion("refundType =", value, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeNotEqualTo(Integer value) {
            addCriterion("refundType <>", value, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeGreaterThan(Integer value) {
            addCriterion("refundType >", value, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("refundType >=", value, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeLessThan(Integer value) {
            addCriterion("refundType <", value, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeLessThanOrEqualTo(Integer value) {
            addCriterion("refundType <=", value, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeIn(List<Integer> values) {
            addCriterion("refundType in", values, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeNotIn(List<Integer> values) {
            addCriterion("refundType not in", values, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeBetween(Integer value1, Integer value2) {
            addCriterion("refundType between", value1, value2, "refundtype");
            return (Criteria) this;
        }

        public Criteria andRefundtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("refundType not between", value1, value2, "refundtype");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetIsNull() {
            addCriterion("agentBusget is null");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetIsNotNull() {
            addCriterion("agentBusget is not null");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetEqualTo(BigDecimal value) {
            addCriterion("agentBusget =", value, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetNotEqualTo(BigDecimal value) {
            addCriterion("agentBusget <>", value, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetGreaterThan(BigDecimal value) {
            addCriterion("agentBusget >", value, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("agentBusget >=", value, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetLessThan(BigDecimal value) {
            addCriterion("agentBusget <", value, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("agentBusget <=", value, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetIn(List<BigDecimal> values) {
            addCriterion("agentBusget in", values, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetNotIn(List<BigDecimal> values) {
            addCriterion("agentBusget not in", values, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("agentBusget between", value1, value2, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAgentbusgetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("agentBusget not between", value1, value2, "agentbusget");
            return (Criteria) this;
        }

        public Criteria andAcoefficientIsNull() {
            addCriterion("acoefficient is null");
            return (Criteria) this;
        }

        public Criteria andAcoefficientIsNotNull() {
            addCriterion("acoefficient is not null");
            return (Criteria) this;
        }

        public Criteria andAcoefficientEqualTo(BigDecimal value) {
            addCriterion("acoefficient =", value, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientNotEqualTo(BigDecimal value) {
            addCriterion("acoefficient <>", value, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientGreaterThan(BigDecimal value) {
            addCriterion("acoefficient >", value, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("acoefficient >=", value, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientLessThan(BigDecimal value) {
            addCriterion("acoefficient <", value, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientLessThanOrEqualTo(BigDecimal value) {
            addCriterion("acoefficient <=", value, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientIn(List<BigDecimal> values) {
            addCriterion("acoefficient in", values, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientNotIn(List<BigDecimal> values) {
            addCriterion("acoefficient not in", values, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("acoefficient between", value1, value2, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficientNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("acoefficient not between", value1, value2, "acoefficient");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2IsNull() {
            addCriterion("acoefficient2 is null");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2IsNotNull() {
            addCriterion("acoefficient2 is not null");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2EqualTo(BigDecimal value) {
            addCriterion("acoefficient2 =", value, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2NotEqualTo(BigDecimal value) {
            addCriterion("acoefficient2 <>", value, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2GreaterThan(BigDecimal value) {
            addCriterion("acoefficient2 >", value, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("acoefficient2 >=", value, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2LessThan(BigDecimal value) {
            addCriterion("acoefficient2 <", value, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("acoefficient2 <=", value, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2In(List<BigDecimal> values) {
            addCriterion("acoefficient2 in", values, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2NotIn(List<BigDecimal> values) {
            addCriterion("acoefficient2 not in", values, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("acoefficient2 between", value1, value2, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAcoefficient2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("acoefficient2 not between", value1, value2, "acoefficient2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2IsNull() {
            addCriterion("agentBusget2 is null");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2IsNotNull() {
            addCriterion("agentBusget2 is not null");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2EqualTo(BigDecimal value) {
            addCriterion("agentBusget2 =", value, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2NotEqualTo(BigDecimal value) {
            addCriterion("agentBusget2 <>", value, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2GreaterThan(BigDecimal value) {
            addCriterion("agentBusget2 >", value, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("agentBusget2 >=", value, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2LessThan(BigDecimal value) {
            addCriterion("agentBusget2 <", value, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("agentBusget2 <=", value, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2In(List<BigDecimal> values) {
            addCriterion("agentBusget2 in", values, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2NotIn(List<BigDecimal> values) {
            addCriterion("agentBusget2 not in", values, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("agentBusget2 between", value1, value2, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andAgentbusget2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("agentBusget2 not between", value1, value2, "agentbusget2");
            return (Criteria) this;
        }

        public Criteria andCoefficientIsNull() {
            addCriterion("coefficient is null");
            return (Criteria) this;
        }

        public Criteria andCoefficientIsNotNull() {
            addCriterion("coefficient is not null");
            return (Criteria) this;
        }

        public Criteria andCoefficientEqualTo(BigDecimal value) {
            addCriterion("coefficient =", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientNotEqualTo(BigDecimal value) {
            addCriterion("coefficient <>", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientGreaterThan(BigDecimal value) {
            addCriterion("coefficient >", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("coefficient >=", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientLessThan(BigDecimal value) {
            addCriterion("coefficient <", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientLessThanOrEqualTo(BigDecimal value) {
            addCriterion("coefficient <=", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientIn(List<BigDecimal> values) {
            addCriterion("coefficient in", values, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientNotIn(List<BigDecimal> values) {
            addCriterion("coefficient not in", values, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coefficient between", value1, value2, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coefficient not between", value1, value2, "coefficient");
            return (Criteria) this;
        }

        public Criteria andIsfirstIsNull() {
            addCriterion("isfirst is null");
            return (Criteria) this;
        }

        public Criteria andIsfirstIsNotNull() {
            addCriterion("isfirst is not null");
            return (Criteria) this;
        }

        public Criteria andIsfirstEqualTo(Integer value) {
            addCriterion("isfirst =", value, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstNotEqualTo(Integer value) {
            addCriterion("isfirst <>", value, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstGreaterThan(Integer value) {
            addCriterion("isfirst >", value, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstGreaterThanOrEqualTo(Integer value) {
            addCriterion("isfirst >=", value, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstLessThan(Integer value) {
            addCriterion("isfirst <", value, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstLessThanOrEqualTo(Integer value) {
            addCriterion("isfirst <=", value, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstIn(List<Integer> values) {
            addCriterion("isfirst in", values, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstNotIn(List<Integer> values) {
            addCriterion("isfirst not in", values, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstBetween(Integer value1, Integer value2) {
            addCriterion("isfirst between", value1, value2, "isfirst");
            return (Criteria) this;
        }

        public Criteria andIsfirstNotBetween(Integer value1, Integer value2) {
            addCriterion("isfirst not between", value1, value2, "isfirst");
            return (Criteria) this;
        }

        public Criteria andPtypeIsNull() {
            addCriterion("ptype is null");
            return (Criteria) this;
        }

        public Criteria andPtypeIsNotNull() {
            addCriterion("ptype is not null");
            return (Criteria) this;
        }

        public Criteria andPtypeEqualTo(Integer value) {
            addCriterion("ptype =", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeNotEqualTo(Integer value) {
            addCriterion("ptype <>", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeGreaterThan(Integer value) {
            addCriterion("ptype >", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ptype >=", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeLessThan(Integer value) {
            addCriterion("ptype <", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeLessThanOrEqualTo(Integer value) {
            addCriterion("ptype <=", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeIn(List<Integer> values) {
            addCriterion("ptype in", values, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeNotIn(List<Integer> values) {
            addCriterion("ptype not in", values, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeBetween(Integer value1, Integer value2) {
            addCriterion("ptype between", value1, value2, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ptype not between", value1, value2, "ptype");
            return (Criteria) this;
        }

        public Criteria andZjzdIsNull() {
            addCriterion("zjzd is null");
            return (Criteria) this;
        }

        public Criteria andZjzdIsNotNull() {
            addCriterion("zjzd is not null");
            return (Criteria) this;
        }

        public Criteria andZjzdEqualTo(BigDecimal value) {
            addCriterion("zjzd =", value, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdNotEqualTo(BigDecimal value) {
            addCriterion("zjzd <>", value, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdGreaterThan(BigDecimal value) {
            addCriterion("zjzd >", value, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("zjzd >=", value, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdLessThan(BigDecimal value) {
            addCriterion("zjzd <", value, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("zjzd <=", value, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdIn(List<BigDecimal> values) {
            addCriterion("zjzd in", values, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdNotIn(List<BigDecimal> values) {
            addCriterion("zjzd not in", values, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("zjzd between", value1, value2, "zjzd");
            return (Criteria) this;
        }

        public Criteria andZjzdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("zjzd not between", value1, value2, "zjzd");
            return (Criteria) this;
        }

        public Criteria andRange1IsNull() {
            addCriterion("range1 is null");
            return (Criteria) this;
        }

        public Criteria andRange1IsNotNull() {
            addCriterion("range1 is not null");
            return (Criteria) this;
        }

        public Criteria andRange1EqualTo(Integer value) {
            addCriterion("range1 =", value, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1NotEqualTo(Integer value) {
            addCriterion("range1 <>", value, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1GreaterThan(Integer value) {
            addCriterion("range1 >", value, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1GreaterThanOrEqualTo(Integer value) {
            addCriterion("range1 >=", value, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1LessThan(Integer value) {
            addCriterion("range1 <", value, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1LessThanOrEqualTo(Integer value) {
            addCriterion("range1 <=", value, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1In(List<Integer> values) {
            addCriterion("range1 in", values, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1NotIn(List<Integer> values) {
            addCriterion("range1 not in", values, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1Between(Integer value1, Integer value2) {
            addCriterion("range1 between", value1, value2, "range1");
            return (Criteria) this;
        }

        public Criteria andRange1NotBetween(Integer value1, Integer value2) {
            addCriterion("range1 not between", value1, value2, "range1");
            return (Criteria) this;
        }

        public Criteria andStypeIsNull() {
            addCriterion("stype is null");
            return (Criteria) this;
        }

        public Criteria andStypeIsNotNull() {
            addCriterion("stype is not null");
            return (Criteria) this;
        }

        public Criteria andStypeEqualTo(Integer value) {
            addCriterion("stype =", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeNotEqualTo(Integer value) {
            addCriterion("stype <>", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeGreaterThan(Integer value) {
            addCriterion("stype >", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("stype >=", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeLessThan(Integer value) {
            addCriterion("stype <", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeLessThanOrEqualTo(Integer value) {
            addCriterion("stype <=", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeIn(List<Integer> values) {
            addCriterion("stype in", values, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeNotIn(List<Integer> values) {
            addCriterion("stype not in", values, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeBetween(Integer value1, Integer value2) {
            addCriterion("stype between", value1, value2, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeNotBetween(Integer value1, Integer value2) {
            addCriterion("stype not between", value1, value2, "stype");
            return (Criteria) this;
        }

        public Criteria andCouponnameIsNull() {
            addCriterion("couponname is null");
            return (Criteria) this;
        }

        public Criteria andCouponnameIsNotNull() {
            addCriterion("couponname is not null");
            return (Criteria) this;
        }

        public Criteria andCouponnameEqualTo(String value) {
            addCriterion("couponname =", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameNotEqualTo(String value) {
            addCriterion("couponname <>", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameGreaterThan(String value) {
            addCriterion("couponname >", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameGreaterThanOrEqualTo(String value) {
            addCriterion("couponname >=", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameLessThan(String value) {
            addCriterion("couponname <", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameLessThanOrEqualTo(String value) {
            addCriterion("couponname <=", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameLike(String value) {
            addCriterion("couponname like", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameNotLike(String value) {
            addCriterion("couponname not like", value, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameIn(List<String> values) {
            addCriterion("couponname in", values, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameNotIn(List<String> values) {
            addCriterion("couponname not in", values, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameBetween(String value1, String value2) {
            addCriterion("couponname between", value1, value2, "couponname");
            return (Criteria) this;
        }

        public Criteria andCouponnameNotBetween(String value1, String value2) {
            addCriterion("couponname not between", value1, value2, "couponname");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNull() {
            addCriterion("payType is null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNotNull() {
            addCriterion("payType is not null");
            return (Criteria) this;
        }

        public Criteria andPaytypeEqualTo(Integer value) {
            addCriterion("payType =", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotEqualTo(Integer value) {
            addCriterion("payType <>", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThan(Integer value) {
            addCriterion("payType >", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("payType >=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThan(Integer value) {
            addCriterion("payType <", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThanOrEqualTo(Integer value) {
            addCriterion("payType <=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeIn(List<Integer> values) {
            addCriterion("payType in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotIn(List<Integer> values) {
            addCriterion("payType not in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeBetween(Integer value1, Integer value2) {
            addCriterion("payType between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotBetween(Integer value1, Integer value2) {
            addCriterion("payType not between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIsNull() {
            addCriterion("orderNumber is null");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIsNotNull() {
            addCriterion("orderNumber is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernumberEqualTo(Integer value) {
            addCriterion("orderNumber =", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotEqualTo(Integer value) {
            addCriterion("orderNumber <>", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberGreaterThan(Integer value) {
            addCriterion("orderNumber >", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderNumber >=", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberLessThan(Integer value) {
            addCriterion("orderNumber <", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberLessThanOrEqualTo(Integer value) {
            addCriterion("orderNumber <=", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIn(List<Integer> values) {
            addCriterion("orderNumber in", values, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotIn(List<Integer> values) {
            addCriterion("orderNumber not in", values, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberBetween(Integer value1, Integer value2) {
            addCriterion("orderNumber between", value1, value2, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotBetween(Integer value1, Integer value2) {
            addCriterion("orderNumber not between", value1, value2, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andAccpttimeIsNull() {
            addCriterion("accptTime is null");
            return (Criteria) this;
        }

        public Criteria andAccpttimeIsNotNull() {
            addCriterion("accptTime is not null");
            return (Criteria) this;
        }

        public Criteria andAccpttimeEqualTo(Date value) {
            addCriterion("accptTime =", value, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeNotEqualTo(Date value) {
            addCriterion("accptTime <>", value, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeGreaterThan(Date value) {
            addCriterion("accptTime >", value, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("accptTime >=", value, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeLessThan(Date value) {
            addCriterion("accptTime <", value, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeLessThanOrEqualTo(Date value) {
            addCriterion("accptTime <=", value, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeIn(List<Date> values) {
            addCriterion("accptTime in", values, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeNotIn(List<Date> values) {
            addCriterion("accptTime not in", values, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeBetween(Date value1, Date value2) {
            addCriterion("accptTime between", value1, value2, "accpttime");
            return (Criteria) this;
        }

        public Criteria andAccpttimeNotBetween(Date value1, Date value2) {
            addCriterion("accptTime not between", value1, value2, "accpttime");
            return (Criteria) this;
        }

        public Criteria andIsaccptIsNull() {
            addCriterion("isaccpt is null");
            return (Criteria) this;
        }

        public Criteria andIsaccptIsNotNull() {
            addCriterion("isaccpt is not null");
            return (Criteria) this;
        }

        public Criteria andIsaccptEqualTo(Integer value) {
            addCriterion("isaccpt =", value, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptNotEqualTo(Integer value) {
            addCriterion("isaccpt <>", value, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptGreaterThan(Integer value) {
            addCriterion("isaccpt >", value, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptGreaterThanOrEqualTo(Integer value) {
            addCriterion("isaccpt >=", value, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptLessThan(Integer value) {
            addCriterion("isaccpt <", value, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptLessThanOrEqualTo(Integer value) {
            addCriterion("isaccpt <=", value, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptIn(List<Integer> values) {
            addCriterion("isaccpt in", values, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptNotIn(List<Integer> values) {
            addCriterion("isaccpt not in", values, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptBetween(Integer value1, Integer value2) {
            addCriterion("isaccpt between", value1, value2, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andIsaccptNotBetween(Integer value1, Integer value2) {
            addCriterion("isaccpt not between", value1, value2, "isaccpt");
            return (Criteria) this;
        }

        public Criteria andPushtypeIsNull() {
            addCriterion("pushType is null");
            return (Criteria) this;
        }

        public Criteria andPushtypeIsNotNull() {
            addCriterion("pushType is not null");
            return (Criteria) this;
        }

        public Criteria andPushtypeEqualTo(Integer value) {
            addCriterion("pushType =", value, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeNotEqualTo(Integer value) {
            addCriterion("pushType <>", value, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeGreaterThan(Integer value) {
            addCriterion("pushType >", value, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("pushType >=", value, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeLessThan(Integer value) {
            addCriterion("pushType <", value, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeLessThanOrEqualTo(Integer value) {
            addCriterion("pushType <=", value, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeIn(List<Integer> values) {
            addCriterion("pushType in", values, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeNotIn(List<Integer> values) {
            addCriterion("pushType not in", values, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeBetween(Integer value1, Integer value2) {
            addCriterion("pushType between", value1, value2, "pushtype");
            return (Criteria) this;
        }

        public Criteria andPushtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("pushType not between", value1, value2, "pushtype");
            return (Criteria) this;
        }

        public Criteria andUserphoneIsNull() {
            addCriterion("userPhone is null");
            return (Criteria) this;
        }

        public Criteria andUserphoneIsNotNull() {
            addCriterion("userPhone is not null");
            return (Criteria) this;
        }

        public Criteria andUserphoneEqualTo(String value) {
            addCriterion("userPhone =", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneNotEqualTo(String value) {
            addCriterion("userPhone <>", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneGreaterThan(String value) {
            addCriterion("userPhone >", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneGreaterThanOrEqualTo(String value) {
            addCriterion("userPhone >=", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneLessThan(String value) {
            addCriterion("userPhone <", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneLessThanOrEqualTo(String value) {
            addCriterion("userPhone <=", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneLike(String value) {
            addCriterion("userPhone like", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneNotLike(String value) {
            addCriterion("userPhone not like", value, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneIn(List<String> values) {
            addCriterion("userPhone in", values, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneNotIn(List<String> values) {
            addCriterion("userPhone not in", values, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneBetween(String value1, String value2) {
            addCriterion("userPhone between", value1, value2, "userphone");
            return (Criteria) this;
        }

        public Criteria andUserphoneNotBetween(String value1, String value2) {
            addCriterion("userPhone not between", value1, value2, "userphone");
            return (Criteria) this;
        }

        public Criteria andApporwxIsNull() {
            addCriterion("appOrwx is null");
            return (Criteria) this;
        }

        public Criteria andApporwxIsNotNull() {
            addCriterion("appOrwx is not null");
            return (Criteria) this;
        }

        public Criteria andApporwxEqualTo(Integer value) {
            addCriterion("appOrwx =", value, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxNotEqualTo(Integer value) {
            addCriterion("appOrwx <>", value, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxGreaterThan(Integer value) {
            addCriterion("appOrwx >", value, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxGreaterThanOrEqualTo(Integer value) {
            addCriterion("appOrwx >=", value, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxLessThan(Integer value) {
            addCriterion("appOrwx <", value, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxLessThanOrEqualTo(Integer value) {
            addCriterion("appOrwx <=", value, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxIn(List<Integer> values) {
            addCriterion("appOrwx in", values, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxNotIn(List<Integer> values) {
            addCriterion("appOrwx not in", values, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxBetween(Integer value1, Integer value2) {
            addCriterion("appOrwx between", value1, value2, "apporwx");
            return (Criteria) this;
        }

        public Criteria andApporwxNotBetween(Integer value1, Integer value2) {
            addCriterion("appOrwx not between", value1, value2, "apporwx");
            return (Criteria) this;
        }

        public Criteria andReadytimeIsNull() {
            addCriterion("readyTime is null");
            return (Criteria) this;
        }

        public Criteria andReadytimeIsNotNull() {
            addCriterion("readyTime is not null");
            return (Criteria) this;
        }

        public Criteria andReadytimeEqualTo(Date value) {
            addCriterion("readyTime =", value, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeNotEqualTo(Date value) {
            addCriterion("readyTime <>", value, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeGreaterThan(Date value) {
            addCriterion("readyTime >", value, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("readyTime >=", value, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeLessThan(Date value) {
            addCriterion("readyTime <", value, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeLessThanOrEqualTo(Date value) {
            addCriterion("readyTime <=", value, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeIn(List<Date> values) {
            addCriterion("readyTime in", values, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeNotIn(List<Date> values) {
            addCriterion("readyTime not in", values, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeBetween(Date value1, Date value2) {
            addCriterion("readyTime between", value1, value2, "readytime");
            return (Criteria) this;
        }

        public Criteria andReadytimeNotBetween(Date value1, Date value2) {
            addCriterion("readyTime not between", value1, value2, "readytime");
            return (Criteria) this;
        }

        public Criteria andDistimeIsNull() {
            addCriterion("disTime is null");
            return (Criteria) this;
        }

        public Criteria andDistimeIsNotNull() {
            addCriterion("disTime is not null");
            return (Criteria) this;
        }

        public Criteria andDistimeEqualTo(Date value) {
            addCriterion("disTime =", value, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeNotEqualTo(Date value) {
            addCriterion("disTime <>", value, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeGreaterThan(Date value) {
            addCriterion("disTime >", value, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeGreaterThanOrEqualTo(Date value) {
            addCriterion("disTime >=", value, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeLessThan(Date value) {
            addCriterion("disTime <", value, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeLessThanOrEqualTo(Date value) {
            addCriterion("disTime <=", value, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeIn(List<Date> values) {
            addCriterion("disTime in", values, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeNotIn(List<Date> values) {
            addCriterion("disTime not in", values, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeBetween(Date value1, Date value2) {
            addCriterion("disTime between", value1, value2, "distime");
            return (Criteria) this;
        }

        public Criteria andDistimeNotBetween(Date value1, Date value2) {
            addCriterion("disTime not between", value1, value2, "distime");
            return (Criteria) this;
        }

        public Criteria andErrendIsNull() {
            addCriterion("errend is null");
            return (Criteria) this;
        }

        public Criteria andErrendIsNotNull() {
            addCriterion("errend is not null");
            return (Criteria) this;
        }

        public Criteria andErrendEqualTo(Integer value) {
            addCriterion("errend =", value, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendNotEqualTo(Integer value) {
            addCriterion("errend <>", value, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendGreaterThan(Integer value) {
            addCriterion("errend >", value, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendGreaterThanOrEqualTo(Integer value) {
            addCriterion("errend >=", value, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendLessThan(Integer value) {
            addCriterion("errend <", value, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendLessThanOrEqualTo(Integer value) {
            addCriterion("errend <=", value, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendIn(List<Integer> values) {
            addCriterion("errend in", values, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendNotIn(List<Integer> values) {
            addCriterion("errend not in", values, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendBetween(Integer value1, Integer value2) {
            addCriterion("errend between", value1, value2, "errend");
            return (Criteria) this;
        }

        public Criteria andErrendNotBetween(Integer value1, Integer value2) {
            addCriterion("errend not between", value1, value2, "errend");
            return (Criteria) this;
        }

        public Criteria andTeamidIsNull() {
            addCriterion("teamid is null");
            return (Criteria) this;
        }

        public Criteria andTeamidIsNotNull() {
            addCriterion("teamid is not null");
            return (Criteria) this;
        }

        public Criteria andTeamidEqualTo(Integer value) {
            addCriterion("teamid =", value, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidNotEqualTo(Integer value) {
            addCriterion("teamid <>", value, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidGreaterThan(Integer value) {
            addCriterion("teamid >", value, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidGreaterThanOrEqualTo(Integer value) {
            addCriterion("teamid >=", value, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidLessThan(Integer value) {
            addCriterion("teamid <", value, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidLessThanOrEqualTo(Integer value) {
            addCriterion("teamid <=", value, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidIn(List<Integer> values) {
            addCriterion("teamid in", values, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidNotIn(List<Integer> values) {
            addCriterion("teamid not in", values, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidBetween(Integer value1, Integer value2) {
            addCriterion("teamid between", value1, value2, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamidNotBetween(Integer value1, Integer value2) {
            addCriterion("teamid not between", value1, value2, "teamid");
            return (Criteria) this;
        }

        public Criteria andTeamnameIsNull() {
            addCriterion("teamname is null");
            return (Criteria) this;
        }

        public Criteria andTeamnameIsNotNull() {
            addCriterion("teamname is not null");
            return (Criteria) this;
        }

        public Criteria andTeamnameEqualTo(String value) {
            addCriterion("teamname =", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameNotEqualTo(String value) {
            addCriterion("teamname <>", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameGreaterThan(String value) {
            addCriterion("teamname >", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameGreaterThanOrEqualTo(String value) {
            addCriterion("teamname >=", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameLessThan(String value) {
            addCriterion("teamname <", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameLessThanOrEqualTo(String value) {
            addCriterion("teamname <=", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameLike(String value) {
            addCriterion("teamname like", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameNotLike(String value) {
            addCriterion("teamname not like", value, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameIn(List<String> values) {
            addCriterion("teamname in", values, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameNotIn(List<String> values) {
            addCriterion("teamname not in", values, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameBetween(String value1, String value2) {
            addCriterion("teamname between", value1, value2, "teamname");
            return (Criteria) this;
        }

        public Criteria andTeamnameNotBetween(String value1, String value2) {
            addCriterion("teamname not between", value1, value2, "teamname");
            return (Criteria) this;
        }

        public Criteria andIstimerefundIsNull() {
            addCriterion("istimerefund is null");
            return (Criteria) this;
        }

        public Criteria andIstimerefundIsNotNull() {
            addCriterion("istimerefund is not null");
            return (Criteria) this;
        }

        public Criteria andIstimerefundEqualTo(Integer value) {
            addCriterion("istimerefund =", value, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundNotEqualTo(Integer value) {
            addCriterion("istimerefund <>", value, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundGreaterThan(Integer value) {
            addCriterion("istimerefund >", value, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundGreaterThanOrEqualTo(Integer value) {
            addCriterion("istimerefund >=", value, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundLessThan(Integer value) {
            addCriterion("istimerefund <", value, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundLessThanOrEqualTo(Integer value) {
            addCriterion("istimerefund <=", value, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundIn(List<Integer> values) {
            addCriterion("istimerefund in", values, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundNotIn(List<Integer> values) {
            addCriterion("istimerefund not in", values, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundBetween(Integer value1, Integer value2) {
            addCriterion("istimerefund between", value1, value2, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIstimerefundNotBetween(Integer value1, Integer value2) {
            addCriterion("istimerefund not between", value1, value2, "istimerefund");
            return (Criteria) this;
        }

        public Criteria andIssubsidyIsNull() {
            addCriterion("issubsidy is null");
            return (Criteria) this;
        }

        public Criteria andIssubsidyIsNotNull() {
            addCriterion("issubsidy is not null");
            return (Criteria) this;
        }

        public Criteria andIssubsidyEqualTo(Integer value) {
            addCriterion("issubsidy =", value, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyNotEqualTo(Integer value) {
            addCriterion("issubsidy <>", value, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyGreaterThan(Integer value) {
            addCriterion("issubsidy >", value, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyGreaterThanOrEqualTo(Integer value) {
            addCriterion("issubsidy >=", value, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyLessThan(Integer value) {
            addCriterion("issubsidy <", value, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyLessThanOrEqualTo(Integer value) {
            addCriterion("issubsidy <=", value, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyIn(List<Integer> values) {
            addCriterion("issubsidy in", values, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyNotIn(List<Integer> values) {
            addCriterion("issubsidy not in", values, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyBetween(Integer value1, Integer value2) {
            addCriterion("issubsidy between", value1, value2, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andIssubsidyNotBetween(Integer value1, Integer value2) {
            addCriterion("issubsidy not between", value1, value2, "issubsidy");
            return (Criteria) this;
        }

        public Criteria andLesspsIsNull() {
            addCriterion("lessps is null");
            return (Criteria) this;
        }

        public Criteria andLesspsIsNotNull() {
            addCriterion("lessps is not null");
            return (Criteria) this;
        }

        public Criteria andLesspsEqualTo(BigDecimal value) {
            addCriterion("lessps =", value, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsNotEqualTo(BigDecimal value) {
            addCriterion("lessps <>", value, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsGreaterThan(BigDecimal value) {
            addCriterion("lessps >", value, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("lessps >=", value, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsLessThan(BigDecimal value) {
            addCriterion("lessps <", value, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("lessps <=", value, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsIn(List<BigDecimal> values) {
            addCriterion("lessps in", values, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsNotIn(List<BigDecimal> values) {
            addCriterion("lessps not in", values, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("lessps between", value1, value2, "lessps");
            return (Criteria) this;
        }

        public Criteria andLesspsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("lessps not between", value1, value2, "lessps");
            return (Criteria) this;
        }

        public Criteria andSubsidyIsNull() {
            addCriterion("subsidy is null");
            return (Criteria) this;
        }

        public Criteria andSubsidyIsNotNull() {
            addCriterion("subsidy is not null");
            return (Criteria) this;
        }

        public Criteria andSubsidyEqualTo(BigDecimal value) {
            addCriterion("subsidy =", value, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyNotEqualTo(BigDecimal value) {
            addCriterion("subsidy <>", value, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyGreaterThan(BigDecimal value) {
            addCriterion("subsidy >", value, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("subsidy >=", value, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyLessThan(BigDecimal value) {
            addCriterion("subsidy <", value, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("subsidy <=", value, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyIn(List<BigDecimal> values) {
            addCriterion("subsidy in", values, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyNotIn(List<BigDecimal> values) {
            addCriterion("subsidy not in", values, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("subsidy between", value1, value2, "subsidy");
            return (Criteria) this;
        }

        public Criteria andSubsidyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("subsidy not between", value1, value2, "subsidy");
            return (Criteria) this;
        }

        public Criteria andAgreeIsNull() {
            addCriterion("agree is null");
            return (Criteria) this;
        }

        public Criteria andAgreeIsNotNull() {
            addCriterion("agree is not null");
            return (Criteria) this;
        }

        public Criteria andAgreeEqualTo(Integer value) {
            addCriterion("agree =", value, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeNotEqualTo(Integer value) {
            addCriterion("agree <>", value, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeGreaterThan(Integer value) {
            addCriterion("agree >", value, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeGreaterThanOrEqualTo(Integer value) {
            addCriterion("agree >=", value, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeLessThan(Integer value) {
            addCriterion("agree <", value, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeLessThanOrEqualTo(Integer value) {
            addCriterion("agree <=", value, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeIn(List<Integer> values) {
            addCriterion("agree in", values, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeNotIn(List<Integer> values) {
            addCriterion("agree not in", values, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeBetween(Integer value1, Integer value2) {
            addCriterion("agree between", value1, value2, "agree");
            return (Criteria) this;
        }

        public Criteria andAgreeNotBetween(Integer value1, Integer value2) {
            addCriterion("agree not between", value1, value2, "agree");
            return (Criteria) this;
        }

        public Criteria andContent1IsNull() {
            addCriterion("content1 is null");
            return (Criteria) this;
        }

        public Criteria andContent1IsNotNull() {
            addCriterion("content1 is not null");
            return (Criteria) this;
        }

        public Criteria andContent1EqualTo(String value) {
            addCriterion("content1 =", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1NotEqualTo(String value) {
            addCriterion("content1 <>", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1GreaterThan(String value) {
            addCriterion("content1 >", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1GreaterThanOrEqualTo(String value) {
            addCriterion("content1 >=", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1LessThan(String value) {
            addCriterion("content1 <", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1LessThanOrEqualTo(String value) {
            addCriterion("content1 <=", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1Like(String value) {
            addCriterion("content1 like", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1NotLike(String value) {
            addCriterion("content1 not like", value, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1In(List<String> values) {
            addCriterion("content1 in", values, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1NotIn(List<String> values) {
            addCriterion("content1 not in", values, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1Between(String value1, String value2) {
            addCriterion("content1 between", value1, value2, "content1");
            return (Criteria) this;
        }

        public Criteria andContent1NotBetween(String value1, String value2) {
            addCriterion("content1 not between", value1, value2, "content1");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}